To bulk update items from the Honeywell MK5502 or excel file use the following steps:
Manually update purchase information in bulk:
- From the website, login to CStorePro
- Go to Price Book > Bulk Update Items.
- On the top right click on Purchase Packs button.
- Search the item using the search criteria identified.
- Enter the purchase information and click on the down arrow next to new purchase blue to apply changes to all the items.
- Click on Save Changes button to save the changes
From Honeywell MK5502
- Click on escape until you are on the main menu.
- Click on option 1 to run program.
- Select option 4 to create pack.
- Enter in the appropriate information and click on the return key once done.
- Repeat step 4 for additional items.
- Once done, upload the file from the cradle on the back office PC.
- Login to your CStorePro account.
- Click on Pricebook -> items.
- Select the By File Upload button on the top right.
- Find the file and process the upload.
From Excel or .csv file:
In excel or .csv file (comma seperated), you will need to enter the the purchase information in the following format:
Item Bar code, Qty, Case Cost, Item/Case, Item Price, Description
Where:
- Item Barcode is the complete 8 or 12 digits on the selling item
- Quantity is the quantity received.
- Case Cost is the cost per case for the item.
- Items/case is the selling units per case.
- Item price is the retail price you wish to sell the item for.
- Description is the selling items description.
Save this file as a .csv and follow these steps
- Login to your CStorePro account.
- Click on Pricebook -> items.
- Select the By File Upload button on the top right.
- Find the file and process the upload.
NOTE: The CSV file should not contain a header with the text.