Importing Inventory Through a CSV File
Importing inventory from a CSV file
If you have items you want to import that are not in your e-commerce system, or you aren’t integrated with an e-commerce system, you can import your items using the CSV file format. CSV stands for “Comma Separated Values” and it just means that its a text file that is formatted using a specific approach, with commas separating data values and quotes used to encapsulate data entries. Many programs support saving CSV files including most text editors and most importantly Microsoft Excel.
Before we get into the import process, we first have to make an important note: Bizelo uses the CSV process to import items into our own systems. However, we do not in turn push inventory into any connected e-commerce systems! This is because we only support a subset of the data needed by ecommerce storefronts — the part dealing with inventory. If you want to get your data into your e-commerce system, you have to first import it there. Then use the Sync approach we list above to in turn get that data into Bizelo IPS.
Bizelo has a CSV importer that uses three steps to get your data into our system.
Step 1: Go to Inventory -> Import and Upload your CSV File
Click on the “Inventory” green navigation tab near the top of the page and select the “Import” option on the right blue side bar. You will be presented with a screen that asks you to upload your CSV file. If you have used traditional CSV defaults, then this is pretty much all you need to do. If you have a specific format that uses different delimeters or text encapsulation, you can seleect the “advanced options” opener and it should prompt you for specifics.
Also, note that you can specify the date on which the inventory quantities reflected in your CSV file are for. For example, if you’re uploading inventory from a week ago so you can support orders that have come in since that time, specify the date in the Date box and upload your inventory. You can then pick your orders from this inventory and your final numbers will reflect your quantities as they are in effect as of the current date.
Step 2: Map the fields in your CSV file to fields that Bizeo supports
Once you complete this step, you will be prompted to map the fields in your CSV file to fields that Bizeo supports. Please note that you must have the “SKU” field set up and at least one item detail field, such as a product name or quantity.
Step 3: File Import Success or Error
Once this step is completed, the file will either be imported successfully, or you’ll see an error message detailing the steps to be corrected. If you have any problems with your CSV import, please let us know by submitting a Support Ticket at http://support.bizelo.com
Importing from an XML file
At this time, Bizelo supports XML (eXtensible Markup Language) file importing on a case-by-case basis. This is because while XML is a standard, it’s particularly flexible (hence why it’s called extensible). This means that no two XML formatted documents are the same — not only in data, but in structure. XML allows unlimited levels of nesting, repeated elements, and even optional elements. Anything can and does go with XML files, which is why we (or anyone) can’t generically support XML. We have to first get a copy of the XML file you wish to import and then set up a specific filter for you. Because this is a manual process, we charge a one-time $49 fee to set up an XML import filter for you. As long as your XML format doesn’t change, you won’t need to ever pay this fee again.