Importing ProductsIf you have more than a few products you will be able to save a lot of time by using our import tool. With import you can load hundreds or even thousands of products into your Storbie store from an external file with just a few clicks. Also, if you have a number of changes to make to your catalogue, such as changing many of your prices, you can export your products to a file, make the changes using a tool such as Microsoft Excel and then import the changes. Another common use of this feature is to use it to synchronise all of your stock levels with an external system.
How to import your products into Storbie
- Navigate to the Products tab in the Manage area.
- On the right hand side of your screen you will see Import Products, click on this button.
- In the top menu (Product Import overview), you will see two links that read sample. There are two options a basic sample file with very simple information to import products quickly or a sample file with more detail to allow you to add much more information about your products before they are imported.
- Click on the one you prefer and it will download as a .CSV.
- Open the file in the your preferred editor and enter your product information.
- When you are finished save it as a CSV file, and you can now import it into your Storbie Shop using the Import Products button
CSVImport/export requires you to have a CSV (comma separated values) file that contains information about your products. A CSV file is a text file that looks a bit like a table of information, one row per table row, with the columns of information separated by commas. The first row is often a table header row which names the columns that will be supplied in all of the remaining rows.
Product Import File FormatThe following table summarises the columns that you can include in your product catalogue CSV file. Only a few of the columns are required. If you don’t include a column and the product doesn’t exist yet then the product will be set to a default value. If the product already exists then the column will be left at its current value. You can include additional columns in your CSV if you wish as they will be ignored.
The Product-ID column is used to identify the product if it already exists in your shop and the Name and Price columns are only required for new products that don’t already exist in your store. The SKU-ID column is required for products that have more than one SKU because of variations such as colour and size.
If an existing product is not included in your CSV file then it is left as-is.
|Column Name||Data Type||Description||Example|
|Product-ID||Text (max 40)||Product Unique ID||CoffeeMug|
|SKU-ID||Text (max 50)||Unique SKU ID||Large|
|Name||Text (max 100)||Product Name||Coffee Mug|
|Images||List of image paths*||Relative paths of images in the image management area||folder1/folder2/image.jpg; folder1/folder2/image2.jpg|
|Description||HTML||The description you see when you click through to the product details||This is a <b>fantastic</b> product.|
|Summary||HTML||The short description you see in a gallery||This is a <b>fantastic</b> product.|
|Tags||List of text tags*||Tags associated with the product||cup;red|
|Stock||Integer||Current level of stock. Leave blank if stock is unlimited.||5d|
|Price||Money||Unit price of the product.||9.99|
|SpecialPrice||Money||Discounted price. Leave blank for no discounted price.|
|Variation1||Text (max 100)||Name of Variation||Size|
|VariationValue1||Text (max 100)||Value of Variation||Large|
|Variation2||Text (max 100)||Name of Variation||Colour|
|VariationValue2||Text (max 100)||Value of Variation||Red|
|Variation3||Text (max 100)||Name of Variation|
|VariationValue3||Text (max 100)||Value of Variation|
|Url||Text (max 100)||coffee-mug|
|ShippingVariation||List of shipping variation names*||Default|
|Visibility||Visible, Hidden, DisplayAsSold, or EnquiryOnly||Whether the product is visible to buyers||Visible|
|Template||Default, Small Image or Large Image||The template of the product details area||Default|
|ImageBorder||Default, None, Thin or Heavy||The border of the images in the product details||Default|
|OneOff||Yes or No||Whether the product is a one off, such as a single piece of art||Yes|
|ShowInventory||Yes or No||Whether the inventory level is shown to the buyer||Yes|
|LimitedStockThreshold||Integer||The threshold level at which to tell the buyer that the stock is limeted||5|
|ShippingUnits||Decimal||The number of shipping units for the product||1|
|CartLimit||Integer||The maximum number of this product that can be in a single shopping cart||5|
|ProductOptions||List of product option set names*||The product options assoicated with this product||Gift Wrapping;Extended Warranty|
|PageTitle||Text||Page title used for search engine optimisation||Coffee Mug - Carl's Emporium|
|PageDescription||Text||Page description used for search engine optimisation||The Best Coffee Mug available on the market today|
|Keywords||Text||Keywords used for search engine optimisation||Coffee,Mug,Cup,Drink,Hot|
* Lists should be separated by semi-colons. ie. tag 1;tag 2;tag 3
Product Variations and SKUsSome products have variations such as colour and size and therefore have multiple SKUs. A SKU (stock tracked unit) is a particular combination of those variations that a customer can choose to purchase. For example, a large, red hat would be one SKU and a small, red hat would be a second SKU.
When a product has SKUs then you will need to provide a SKU-ID for each of those SKUs so that they can be identified. You can leave this column blank for products that have no variations and therefore have only one SKU in which case the SKU-ID will default to the number ‘1’.
If you include a one or more SKU rows for a particular product, as determined by a matching Product-ID then it is assumed that all SKUs will be in the file so SKUs that are not included in the file for that product will be deleted.
In the above example, the first product with an ID of hat has two SKUs so the SKU-ID has been included. The product with an ID of glove has no variations and so therefore has only one SKU. The SKU-ID can therefore be left blank.
If your store has no products with variations then you can simply leave the SKU-ID and variation columns out of your import altogether.
Importing a Product CatalogueOnce you have your CSV file you can easily use it to update your product catalogue in your store. Because a CSV file can potentially make many changes to your product catalogue we strongly advise you to publish all existing changes to your store before doing an import. This enables you to roll back your product import if you get unexpected results. If you are creating new products, ensure you have uploaded the relevant images with the right file names prior to importing the CSV file.
- Go to the products tab in the shop management area.
- Then click Import Products
- Then click Choose File and select the CSV file you want to upload.
- Click FINISH.
- You will see a message indicating that the product import is in progress.
- When the import is ready the message will indicate that it is complete.
- Refresh the products page to see your imported products.
- Review that the updates are as you expected. If they are, publish the changes to your shop.