Products

Sample CSV

Products-sample.csv

CSV Column Header Required Value Type Example Value
Family ID Text PROD001
Family Name Text Cabernet Sauvignon Reserve
Family Description Text Full-bodied red wine with notes of blackberry and oak
Product type Beer
Wine
Spirits Wine
Variant Name Text
Cabernet Sauvignon Reserve - 2022
Brand Text Acme Reserve
Country 2-Letter Country Code US
Vendor ID Text VEND-0517
(Must match existing vendor ID in Masava)
Visibility Active/Inactive Active
Collection Name Text (Used for price level mix and match) All Wines
ABV Decimal 14.5
Sku Text CAB-00133-22
Bottle Size Number 750
Vintage Year 2022
Vintage Type `Not Applicable
Non-Vintage`
Year Year
Container type Case
Bottle
PET Bottle
Keg
Can
Bag-In-Box
Other Bottle
Purchase Format By Unit
By Case By Unit
Units per case Number 12
Cases per pallet Number 48
Lead time Number in days 14
List price Decimal (No currency symbols) 14.99
Cost price Decimal (No currency symbols) 11.99
Importer Price Decimal (No currency symbols) 10.99
Suggested Retail Price Decimal (No currency symbols) 18.99

Price Levels (Deals)

Sample CSV

Deals-sample.csv

CSV Column Header Required Value Type Example Value
Deal ID Text DEAL-001
Deal Name Text 10 Case
Sku Text CHD-750-2022
Collection Name Text Name of mix-and-match price level collection
Type `Global
Local`
Minimum Requirement Type Units
Cases Cases
Minimum Requirement Value Number 10
Final Price Decimal 72.99 (Final price should be in format specified in Minimum Requirement Type field). So per case in this example.
Status Active
Inactive Active
Customer Group Text All Restaurants
Depletion Allowance Number