ExpandCart offers a feature to help you import and export your products by Excel easily.
It can also be used to update the price, quantity or your product's data, etc., or take a backup of your store's product data in an excel sheet.
Through this article, we will explain how to use this feature to export and import products within your store.
To export your products using excel file, go to the products section from your store’s dashboard.
Then, click on Export
You will be directed to this page to map the product data which will be exported into an excel file.
Language: to choose the language in which the products will be exported in.
Categories: you can select all or certain categories from your store.
Brand: you can select all or certain brands from your store.
Product name: writedown a specific product name to export it’s details.
Model: choose a specific model to export all the products related to it.
Price: choose a price range to export only the products within this selected price range.
Product Quantity: you can specify the quantity of the products you want to export
Product ID - Condition: specify the product IDs for the products you wish to export.
Limit: specify the number of products you wish to export. Preferably leave as is, as it already reflects the actual number of your products.
Stock Status: to specify the stock of status for the products you wish to export (in stock, out of stock, pre-order, 2 -3 days)
Status: choose the status of the products to be exported (enabled, disabled)
Product Options: you can choose the product options to be exported (simple, advanced options)
Export File Format: choose the file format for the exported file. Preferably choose (ExpandCart file format).
Images path: Determines the path of images when exporting the products.
For the Absolute option, the entire image path will be exported with the domain so that the image can be opened from anywhere.
As for the second option, "Relative", the track will be exported from within the control panel, and it cannot be opened.
So, if you wish to copy the products to another platform or store, you must choose "Absolute", but if you wish to export, modify and import the file again on the same store, you can choose "Relative".
Export Format: Leave this field as XLS for the file to be exported as excel file.
To import your products into your store, go to products sections from your store’s dashboard.
Then click on Import
You will be directed to this page.
To make sure that the products will be successfully imported into your store, download the (example file), to check the file format.
After adding and modifying the products, you can upload the products file by clicking on "Choose File" in the "Products" field, then choose the language in which the products will be imported. Also specify the type of product options are chosen (the same type as in the products file must be chosen so that they are properly imported)
It is preferable to choose No options to import products for the first time.
After completion, please click on the Upload button.
After importing the products file, you will be transferred to the Mapping page to link the columns in the file with the corresponding fields in the dashboard.
Please make sure that the correct column is selected with the correct field and review all the fields properly so that products data is added in its correct fields, then click on “Upload” at the bottom of the page.
In case the field and selection are not compatible, please change them in accordance with the correct field, as shown below:
After choosing Upload, you will be directed to this page.
Please wait at least 10 minutes for the full product information to be uploaded, then go to the products section to view the uploaded products.
Note: It is preferable not to upload the file if it contains more than 500 products as it may take a lot of time to be imported, which leads to stopping the process in the event there is a problem in communicating with the Internet, so if you have a huge number of products please divide them into a group of files when uploading then import them sequentially.
Upload products file to add new products, rather than modifying exciting products:
The process of importing products from an excel file is a complex programmatically process, sometimes, so please make sure to follow the below to add new products through the excel file.
1- When importing the product file, make sure to import it in one language only, not all languages, and it is preferred to be the default language for your store.
2- All products are added to the excel file while keeping the field "Product ID" empty, as the presence of a value in this field means that the product already exists and it will be modified but if the field is empty, a new product will be created.
3- The file is imported normally, and all products are added in one language.
4- The file will be imported again in another language while keeping the "Product ID" until the specified product is modified based on the "Product ID".
5- After completing the Excel file setting for the additional languages, you can upload it again to be able to amend the products that were previously uploaded in the default language.
Here’s an attached file to explain the fields of the excel file and how to modify it properly.