You may import inventory directly into Bindo using the Bindo Dashboard importer. The following instructions provide additional information regarding the importer, but if you need assistance importing your inventory please do not hesitate to contact the Bindo Support Team.
To import your inventory, please follow these steps:
This Bindo Inventory Template includes multiple tabs with instructions, examples, as well as a tab for your data. This spreadsheet can be opened using Microsoft Excel or Google Sheets. This file is a .XLSX file with, but keep in mind that your data must be saved as a .CSV file.
Add data into relevant columns on the spreadsheet - note that data is required in some columns and optional in others. Row 2 of the "Your Data - Save as CSV" tab of the Import Template includes text to help you. For example as show here the first column "action" is required, but the second column "bpid" is optional. Make sure that you DO NOT edit any of the column header text in Row 1.
Note that some fields are required on a conditional basis. For example Supplier Name is optional, but if you include a Cost for an item you must also include a Supplier Name. Please refer to row 2 within the template for additional importer rules and information.
Before importing items into your store you must verify that each of the tax rates listed on your spreadsheet exist in your store. If you attempt to import items and the associated tax rate does not exist in your store the import will be rejected. Prior to the import make sure that all Tax Rates listed in column K are also listed in the Tax Options list for your store. Visit this link for more information on managing taxes and tax options.
If using the Import Template from this page delete row 2 from your spreadsheet prior to importing the file - otherwise Bindo will think row 2 is a product! As noted above the file that you import must be a .CSV file - save the relevant tab ("Your Data - Save as CSV") as a .CSV file. If you are importing images make sure files exist for all image file names in column AA and compress image files into a .ZIP file.
Log into your store on the Bindo Dashboard and navigate to the Inventory page. Click on the "Import" button in the bottom right corner of the screen. Click on the "Choose File" button and select the CSV file only (if you have images they will be added later).
Once you add your file, validation will begin as indicated by the below message. Note that if you are uploading a large number of products the validation process may take a couple of minutes. Do not close your browser window during this process.
Following the CSV file upload you may upload your ZIP file containing images. The image file upload button will only appear if your CSV file passes validation. If you do not have images to upload simply skip the image file upload.
Click the orange "Import" button to complete the import. Once the import is complete you will see a success message, note that the import may take several minutes to complete.
During the import process you may encounter warnings or errors which display following the CSV file validation process. Warnings are messages that are for your information only and do not prevent a file from being imported, whereas errors must be corrected prior to file import. If you are not sure how to correct an error please contact us at email@example.com.
File can't be open
Your file may be corrupted, or the upload process has been terminated due to an unstable network. Please export a new .csv file and try again.
File is not in UTF-8
Your file does not have the correct encoding format. The importer supports UTF-8 encoding only.
To fix this error:
Listing # is too large (>10000 rows)
Leading or ending empty space found in field
Listing name must be provided
Qty on shelf is not provided
Qty on shelf must be a number
Qty in stockroom is not provided
Qty in stockroom must be a number
Secondary Bar code is duplicated in csv
Secondary Bar code is duplicated in db
Standard price must be provided
Standard price must be a number
Tax name not found
# of Serial Number should equal to # of Qty on shelf
Serial Number is duplicated in same listing
In store only accepts only Y or N
Discontinued accepts only Y or N
Supplier product id must come with supplier name
Cost must be provided
Cost must be a number
Cost must come with supplier name
Reorder trigger point must be a number
Reorder trigger point must come with supplier name
Reorder amount must be a number
Reorder amount must come with supplier name
Parent name is duplicated in db
Matrix attributes is not provided
Matrix attributes key duplicated
Matrix attributes key not match
Matrix attributes value duplicated
We provide email support Monday through Friday. We do our best to respond to each request with a personalized reply within 24-48 business hours.