Support Center

Import-Export

Last Updated: Sep 12, 2016 10:24PM EDT

Your Online Store is designed to be a very flexible system allowing import/export of store data in various ways, which can be very useful for store owners as well as for third party applications developers. Your store provides abilities to upload/download your products, orders, customers and other store data either via several APIs or via built-in Import/Export tools:

  • If you need to upload products to your store in mass (or update existing products), you may want to use the 'Import products' tool. Please check the examples of use cases in the FAQ below. For the detailed tool description and troubleshooting, please refer to this article: Importing products.
  • If you need to download your store data in a file either for further editing in a spreadsheet editor or for importing to some third party application, you should use Export tool. 
 

How can I download all my products in a file? 

In order to get your store products, you'll need to use Export tool:

  • Go to Control panel → Catalog → Products
  • Click "Export all" at the bottom of the page
  • In the "Export products" settings pop-up tick the fields you want to export: 'Product name', 'SKU', 'Quantity', etc.
  • Click 'Download CSV file' and save the resulting file on your computer

It is also possible to export just a part of your inventory matching some criteria. You can filter your products in control panel → Catalog → Products using the filters in the column headers or use the product search field on the top right, then click "Export all found". More information: Exporting store data

How can I generate my customers email list? 

You may want to get your customers email list in order to send them email messages in bulk or to export them to some 3d-party email marketing tool (e.g. MailChimp). How to do it:

  • Go to Control panel → Customers
  • Click "Export all" at the bottom of the page
  • In the export settings dialog tick the 'Email' column (you can also export customers names and dates of their registration if needed)
  • Click 'Download CSV file' and save the resulting file on your computer

How can I generate inventory report (my products' stock quantities)?

In order to get a list of your products' stock levels, you'll need to use Export tool:

  • Go to Control panel → Catalog → Products
  • Click "Export all" at the bottom of the page
  • In the "Export products" settings pop-up tick the 'Product name', 'SKU' and 'Quantity' columns
  • Click 'Download CSV file' and save the resulting file on your computer

If you're interested in how many products have been sold in your store for some time interval or in any other sales reports.

It is also possible to get a list of all your products that are out of stock currently. In order to find your "Out of stock products", visit control panel → Catalog → Products, and in the filter above the Availability column of the products table choose "Enabled, but out of stock". The products table will show the out of stock products, that you can export into a file by clicking the "Export all found" button below the table.

How can I get sales reports based on my orders? 

Using sales export tool (Control panel -> Sales -> Orders), you can download your orders data into a CSV file and use it, for example, for generating a report in your spreadsheet editor or importing to some 3d-party sales tracking tool. Please refer to this article for details on how to do it and for other approaches of generating sales reports: 

How can I copy all my products from outside?

Sometimes you need to copy your products from some third-party application or database to your store, e.g. to move products from a file provided by a dropshipper or migrate from another shopping cart. In such situations the most convenient way to add all your products is to use the built-in import tool. Here is how to do it:

  • Get a CSV file that contains your products. If you aren't sure how to get it from the place where your products currently belong, please search for the corresponding info in third-party application's documentation or contact its support on the matter.
  • 2Adjust the file so that it fits CSV import format.
  • Import the resulting CSV file to your control panel (Catalog → Products → Import products)

How can I update my products in bulk?

If you need to change some property of many products in your store, you can use the export-import features for doing it in mass. How to do it:

1. Export the products to a CSV file:

  • Go to Control panel → Catalog → Products
  • Use search filters to find the products that need to be updated
  • Click "Export all found" or "Export all" depending on whether you want to edit all your products or only some of them
  • In the "Export products" settings pop-up mark 'Product name', 'SKU' columns and the ones you want to edit (e.g. price)
  • Click 'Download CSV file' and save the resulting file on your computer

2. Open the CSV file in a spreadsheet editor (e.g. OpenOffice Calc) and edit the columns containing the properties you want to change.

  • By means of the built-in spreadsheet program features, you can quickly update many lines. For example, you can set the same value for the whole column or even apply some formula to a column so that all the values are changed in the same manner. You can insert a formula that will instantly add, subtract, multiply or divide numbers in columns or rows. For example, this way you can add a 10% price markup to all the products - just multiply the whole 'price' column by 1.1 . Please refer to your spreadsheet program's documentation for further details on using formulas.
  • Please make sure the SKU column in your editor has the 'text' type, when you initially open your CSV file. Sometimes, spreadsheet editors recognize numeric SKUs as integer numbers and set 'numeric' format for the SKU column, which results in changing their values (e.g. '0005' becomes '5' when considered a number). This may cause some issues during import, e.g. duplicating of store products. The SKUs in the CSV file must be imported by the spreadsheet editor exactly as you see them in the control panel - setting the text format for the SKU column upon opening the file in the spreadsheet editor does the thing.
  • When saving the changed file, you will most likely be prompted to change the format of the file - that is not what you want, always proceed with saving exactly to CSV format, not to Excel document or Open Document.

3. Import the edited CSV file back to your store. 

  • Go to Control panel → Catalog → Products
  • Click 'Import products' on the top
  • In the import settings popup choose importing from CSV and open the CSV file with the 'Choose file' button
  • Select the delimiter to be used in the exported CSV file (it is semicolon by default)
  • In the 'Import columns' list tick the columns that are present in your CSV file. Important: the column order must be the same as in the CSV file, please re-arrange them if needed (in order to do it you should drag-and-drop the list items)
  • Importantuncheck the 'Delete all products/categories before import' checkbox at the bottom of the window.

Example.

The "Quantity" import field can be used for updating your store inventory. How to do it:

  • Export your products (three columns will be enough: Product name, SKU, Quantity)
  • Modify the CSV file in your spreadsheet editor (change the products quantities)
  • Import the file 

The number in the "Quantity" column will be used to update the quantity of the product with the corresponding SKU or product name. If there is no value in the Quantity column, the "Unlimited quantity" option will be enabled for the product. Example of a CSV file: 


name;sku;quantity
cherry;item132;2
cucumber;item7;
apple;item7635;15

 

How can I increase/decrease all prices in my store in mass?

In order to increase or decrease all the prices in your store in mass, you can use the export/import features. You will need to export your products with their prices, change the CSV file in your spreadsheet editor as you wish and import it back. Please find the detailed instruction here: How can I update my products in bulk?

Hint: in a spreadsheet editor it is possible to apply some action to an entire column - it will let you quickly update the prices for a bunch of products. How to do it:

How can I assign weights to all my products in bulk?

If you have a large number of products in your store and need to assign weights to all of them (e.g. if you need to set up carrier-calculated shipping in your store that requires valid product weights), you can quickly do it by means of the export-import tools. You will need to export your products to a CSV file, change the CSV file in your spreadsheet editor (enter weights) and import it back. 

How can I upload images to my products? 

In your store, you can import the main product images via CSV. Small thumbnails will be created automatically. How to do it:

  • upload your images from your computer to any web server / hosting. Your images should be accessible by direct link, e.g. http://example.com/images/product_1.jpg 
    IMPORTANT: Your store downloads images from secure HTTP/HTTPS protocol. Other protocols are not supported anymore.
  • export your products to a CSV file
  • change the exported file in your spreadsheet editor: add the corresponding URLs to the product lines
  • import the resulting file back

See also: How can I update my products in bulk? 

Can I import my orders into QuickBooks? 

Yes, it is possible using the 3rd party modules providing live integration of your store with Quickbooks: http://support.quickbooks.intuit.com/support/Articles/HOW12247

Liquid error: undefined method `gsub' for nil:NilClass

assistly@premium-webhelp.com
http://assets2.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete