Importing Products

If 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

  1. Navigate to the Products tab in the Manage area.
  2. On the right hand side of your screen you will see Import Products, click on this button.
  3. 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.
  4. Click on the one you prefer and it will download as a .CSV.

  5. Open the file in the your preferred editor and enter your product information. 
  6. 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

CSV

Import/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.

For example:
 

Product Import File Format 

The 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 SKUs

Some 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 Catalogue

Once 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.
  1. Go to the products tab in the shop management area.
  2. Then click Import Products

     
  3. Then click Choose File and select the CSV file you want to upload. 
  4. Click FINISH.
  5. You will see a message indicating that the product import is in progress.
  6. When the import is ready the message will indicate that it is complete.
  7. Refresh the products page to see your imported products.
  8. Review that the updates are as you expected. If they are, publish the changes to your shop.