Knowledge Centre

Extras

Products

Import/Export

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.

Online 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. Please find the details in this article: Exporting store data.

How can I download all my products in a file?
How can I generate my customers email list?
How can I generate inventory report (my products' stock quantities)?
How can I copy all my products to Online store from outside?
How can I update my products in bulk?
How can I increase/decrease all prices in my store in mass?
How can I assign weights to all my products in bulk?
How can I upload images to my products?
Can I import my orders into QuickBooks?

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

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 copy all my products to Online store from outside?

Sometimes you need to copy your products from some third-party application or database to Online store, e.g. to move products from a file provided by a dropshipper or migrate from another shopping cart to Online store. In such situations the most convenient way to add all your products to Online store is to use the store's 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.
Adjust the file so that it fits CSV import format.
Import the resulting CSV file in your control panel (Catalog → Products → Import products)

More information: Importing 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 or a Bulk Product Editor application.

Export-Import features

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 recognise 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 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 Online 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)
Important: uncheck 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 to Online store

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:

More information: Importing products

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 to Online store. 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 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 to Online store. Please find the detailed instruction here: How can I update my products in bulk?

How can I upload images to my products?

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: System 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 to Online store

Can I import my orders into QuickBooks?

Yes, it is totally possible. Please refer to this article for instructions: Quickbooks Online

Alternatively you can export your orders from Online store:

Open the sales section in your control panel: Sales → Orders
Click the 'Export All' button in the bottom of the list or tick the orders you want to export and click "Export selected"
In the export settings dialog, select delimiter and the columns you want to get in a file and press "Download CSV file"
Save the CSV file on your computer

After that you will be able to import this file to Quickbooks.

--------------------------