Import-Export

Last updated

Ecwid 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. Ecwid 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 develop an application that needs to communicate with Ecwid for uploading/downloading your store data, please consider using Ecwid APIs.
  • 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? 

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 Ecwid 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

More information: Exporting store data 

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, please also refer to this article: How can I get sales reports based on my orders in Ecwid

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 Ecwid 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.

More information: Exporting store data 

How can I get sales reports based on my orders in Ecwid? 

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 get sales reports based on my orders in Ecwid?

How can I copy all my products to Ecwid from outside?

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

More information: Importing products

How can I import my customers to Ecwid? 

There is easy way to migrate your customer base to Ecwid. You can do so with the help of free "Import Customers" app: 

  • Install the "Import Customers" app in your Ecwid account: https://www.ecwid.com/apps/storemanagement/ecwid-customers-import
  • Download the template of CSV import file.
  • Using the template, create import file with your customers data in a text editor, for ex. Excel or OpenOffice.
  • Upload the file to the app and it will automatically create new customers in your Ecwid account. 
  • You can leave "password" column empty. In this case we will generate a random password for each customer. 

You'll find the installed app in your Ecwid control panel on My sales > Import Customers page. 

"Import Customers" app is available at no charge for customers on Venture and higher tier plans. If you’re on a Free plan, please, consider upgrading your account to any paid plan. Upgrade to get app

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 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 Ecwid 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 Ecwid. 

  • 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 to Ecwid 

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

More information: Importing products

Bulk Product Editor Application

It is possible to easily update your products in bulk using the app featured in our App market, Bulk Product Editor. The app allows to:

  • Bulk update all products, or filter which you want to change,
  • Change properties like price, weight, quantity and more,
  • Add/remove options, and add/remove choices to these options,
  • Bulk enable/disable products in your store.

You can install the app right in your control panel on the app page in Ecwid App Market.

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

How can I upload images to my products? 

In Ecwid, 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: Ecwid 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 Ecwid

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

How can I upload additional product images (gallery) in bulk?

It is possible to upload gallery images to your Ecwid store in bulk using Bulk Gallery Upload app: https://www.ecwid.com/apps/storemanagement/smartmart-bulk-gallery-upload

The app allows to upload images using a single ZIP-archive, please check this help page for details: https://ecwidbulkgalleryupload-smartmartcomua.rhcloud.com/#quickHelp

The Bulk Gallery Upload app is free, but requires any Ecwid paid plan to access API.

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 Ecwid:

  • 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 (what is it?) 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.

Was this article helpful?
4 out of 5 found this helpful
Questions?
Get help
  • Forums

    Join the Ecwid community. Discuss support topics and store ideas with other Ecwid users.

  • Contact us

    Still have questions about Ecwid? Let us know! We will be glad to help you with your Ecwid store.

  • Status Monitor

    Get real time status updates on Ecwid services here, 24/7