Use the exported sales file as your template. Unique invoice lines are imported once; corrections require a new negative return line.
Download sales CSV templateRequired columns: invoice, customerId, company, productId, date, quantity, netAED, discounted, tradeDeal. Max 500 rows / 500 KB per import. Negative quantity and netAED record a sales return.
Customer IDsatlantis = Atlantis The Palm; jumeirah = Jumeirah Beach Hotel; marina = Buddha-Bar Dubai; four = Four Seasons DIFC; beach = Nikki Beach Dubai; address = Address Downtown
Product IDsgrey = Grey Goose Original Vodka · 75cl; hendricks = Hendrick’s Gin · 70cl; moet = Moët & Chandon Impérial · 75cl; whisper = Whispering Angel Rosé · 75cl; peroni = Peroni Nastro Azzurro · 33cl; seedlip = Seedlip Garden 108 · 70cl