When you open this page, you will first see a section that lists information for the current sales week.
For example:
Sales already recorded for the week of 1/1/2016 to 1/6/2016:
Sales for 1/1/2016 - none entered.
Sales for 1/2/2016 - 1 items for a total of 2 bottles.
Sales for 1/3/2016 - 1 items for a total of 1 bottles.
Sales for 1/4/2016 - none entered.
Sales for 1/5/2016 - none entered.
Sales for 1/6/2016 - none entered.
Below this information, you have a Browse... button to select
the file you want to upload. There is a dropdown next to this link that allows you to select the format
your file is in. (Note that you can change this in your settings.)
After you have selected your file by clicking on the Browse... button and selected the appropriate format, you will need to click on the Import Sales button to add the sales to your store.
The following file formats are all supported import formats. Please see the section below associated with your point-of-sale software/format for more details about your file format.
The file name for a Standard import must be in the following format:
LIQ_yymmdd_REGnn_zz.CSV
where yymmdd is the year/month/day of the sales, nn is the register number, and zz is the sequence number
(each day begins with "01" and increments with each file created for that register on that day).
For example:
liq_160101_reg01_01.csv is the 1st file created for register 1 on January 1st.
Each line inside this comma-delimited file must contain the following information:
Date, NABCA, Bottles
The date must be in mm/dd/yyyy format. You can have more than one date in the same file.
The NABCA code must be a valid NABCA code that is in your store's inventory.
The bottles sold quantity can be positive (a sale) or negative (a return). These are retail sales
(or returns) ONLY -- no licensee sales can be in this file.
For example:
01/01/2016,11296,2 (2 bottles of 11296 were sold on January 1st)
01/01/2016,11298,-1 (1 bottle of 11298 was returned on January 1st)
Tax exempt sales will include an extra field at the end of the line. This field must contain the text
"TAXEX" after the bottles sold quantity. For example:
01/01/2016,11776,2, TAXEX (2 bottles of 11776 were sold, tax exempt, on January 1st)
Please do not include any blank lines or any spaces in this file.
The file name should have the following format:
LIQ_yymmdd_REGnn_zz.CSV
where yymmdd is the year/month/day of the sales, nn is the register number, and zz is the sequence number
(each day begins with "01" and increments with each file created for that register on that day).
For example:
liq_160101_reg01_01.csv is the 1st file created for register 1 on January 1st.
Each line inside this comma-delimited file must contain the following information:
Date, NABCA, Bottles
The date must be in yyyyMMdd format. You can have more than one date in the same file.
The NABCA code must be a valid NABCA code that is in your store's inventory.
The bottles sold quantity can be positive (a sale) or negative (a return). These are retail sales
(or returns) ONLY -- no licensee sales can be in this file.
For example:
20160101,11296,2 (2 bottles of 11296 were sold on January 1st)
20160101,11298,-1 (1 bottle of 11298 was returned on January 1st)
Tax exempt sales will include an extra field at the end of the line. This field must contain the text
"TAXEX" after the bottles sold quantity. For example:
20160101,11776,2, TAXEX (2 bottles of 11776 were sold, tax exempt, on January 1st)
The file name must have the following format:
PLUZ mm-dd-yyyy ##.##.#.CSV
where mm-dd-yyyy is the month/day/year of the sales, and the # symbol represents numbers that the PLUZ system assigns.
For example:
PLUZ 01-01-2016 22.50.3.CSV is for sales on January 1st.
Each line inside this comma-delimited file must contain the following information:
(number), (number), (number), Description, Bottles, Dollars
The first three columns are numbers that are assigned by the PLUZ system, and ignored by our system.
The fourth column, Description, should contain the NABCA code if it is a liquor product. It must be a valid NABCA code that is in your store's inventory.
The bottles sold quantity can be positive (a sale) or negative (a return). These are retail sales
(or returns) ONLY -- no licensee sales can be in this file.
For example:
2103,1,1,BEER,2,13.39 (not liquor -- ignored by our system)
2103,2,2,POP,1,1.98 (not liquor -- ignored by our system)
2103,3,3,11296,2,26.95 (2 bottles of 11296 were sold)
2103,4,4,11298,-1,49.95 (1 bottle of 11298 was returned)
The file name should have the following format:
LIQ_yymmdd_REGnn_zz.CSV
where yymmdd is the year/month/day of the sales, nn is the register number, and zz is the sequence number
(each day begins with "01" and increments with each file created for that register on that day).
For example:
liq_160101_reg01_01.csv is the 1st file created for register 1 on January 1st.
Each line inside this comma-delimited file will contain the following information:
NABCA, Bottles, Description, Dollars Sold
The NABCA code must be a valid NABCA code that is in your store's inventory.
The bottles sold quantity can be positive (a sale) or negative (a return). These are retail sales
(or returns) ONLY -- no licensee sales can be in this file.
For example:
11296,2,Crown Royal,26.95 (2 bottles of 11296 were sold)
11298,-1,Crown Royal,49.95 (1 bottle of 11298 was returned)
If the sale is tax exempt, the third field (Description) must contain the text
"TAXEX". For example:
11776,2,TAXEX,9.95 (2 bottles of 11776 were sold, tax exempt)