Note: For up-to-date guides on using Delivrd, please refer to official Delivrd documentation.
This how-to guide will explain how you can import new products into Delivrd, the free online inventory management and order fulfillment solution.
When you first start using Delivrd, before you can start processing orders (inbound and outbound), you first need create new products. You can create new products manually, but if you have many products, it’s a lot easier to import products from a text file.
Also, you might already have all your products data available in another system (perhaps your shopping cart app has some product information). You might be able to export your product data from that application and then import it into Delivrd.
In order to import product data, you need to create a CSV file with all product information. Each product will have its information in a separate line in the CSV file.
Here’s how the data in the file might look like:
Structure of the import file
The import file must have the structure explained below. If the structure is not exactly as explained here, Delivrd will not be able to create the products correctly.
Line no.1 – this is a header line, meaning – it does not contain any product data, but rather the name of each field in the import file. This line is not imported into Delivrd, and its purpose is to make it easier to understand the content of the imported data.
As in any CSV file, each field must be separated by a comma (,) sign
Lines no. 2,3,4 etc. – these are the lines which contain the actual product data. Each line must have all data fields(currently, a total of 21 fields). Some fields can be empty, while other fields are mandatory and must contain a valid value.
Here’s a table that describes the fields that should be in the import file, and some of their characteristics.
Product Import File Strcuture
|Field Name||Field Description||Field Data Type||Field Length||Example value||Remarks||Mandatory?|
|LineNumber||Number of product line||Number||2||1,2,3||Yes|
|Name||Product short name||Text||30||Digital LCD Kitchen Buzzer||Yes|
|Description||Product long description||Text||255||Ultrathin Credit Card Sized Digital LCD Kitchen Buzzer Timer with Magnetic Mount||Yes|
|Group||Product group from list of product groups||Text||255||Consumer Electronics||From list of available groups||Yes|
|Weight||Net weight of product||Number with decimals||8||0.52||Yes|
|Width||Width of product||Number with decimals||8||2.3||No|
|Height||Height of product||Number with decimals||8||1.33||No|
|Depth||Depth of product||Number with decimals||8||3.8||No|
|Barcode||Barcode number of product||Number||Usually 12 or 13 digits||7290103120641||No|
|SKU||Products SKU||Text or Numbers||255||148529||Must be unique||Yes|
|PackMaterial||Product id of packaging material||Number||255||35||Yes|
|PackingInstructions||Packing instructions for this product||Text||1028||"Product should be packed in a white box and shipping label should be applied on the left side of the box"||No|
|PaackgingMaterial||Is this product a packaging material?||0 or 1||1||0 - not a packaging material
1- is a packaging material
|Bin||Bin number used for storing this product||Number||10||103
|Value||The value of the product||Number with decimals||8||15.26||Yes|
|SafetyStock||Safety stock levels||Number with decimals||8||12||Yes|
|ImageURL||URL of product's image||Text||1028||http://images.com/thispimages.jpg||Yes|
|PageURL||URL of product's page||Text||1028||http://mywebsite/product1.html||No|
|Color||Color of product||Text||255||Blue||No|
|Size||Size of product||Text||255||XL
Download Sample Product File
The best way to understand how a products import file should look like, is to just click the link below – sample file will be downloaded. You can use it as a template to create your own products import file.
Video demo – importing products from CSV file into Delivrd