Expandcart platform Provide Export and import product files feature inside the store control panel
As this feature is very useful for stores that have a lot of products and want to enter their data in a short time and uploaded to the store, or can be updated on the price data or quantity of the product,,, etc. and then upload the file at your store through excel sheet file , also can download the products are located inside the store by excel files on your computer
Through this article, we will explain to you how to use the export and import products feature inside the store control panel
In order to be able to export the product data file and download it to your computer, please go from the control panel into products than products and then at the top of the page there is an icon called export press at it, the next image for clarification
after clicking the Export icon will appear with you the page settings
- Export the product
This section includes the following fields:
Store: Your e-store name will be the choice (default)
Language: The language you want to download the file is selected on your computer. If you have more than one language on your store, the file will be downloaded on each language separately.
Sections: Through this field, select the section you want to export by excel file
Brand: Through this box, you choose the brand name you want to export by excel file
Product Name: Through this box, you can choose the name of a specific product whose export information is exported in the file
Model: You can write a number or model name associated with the many products you want to export by excel file
Price: Through this icon, you can set the price of the products you want to export excel file to it for an example of the price from 10 to 1000
Quantity: Through this icon, you can specify the quantity of products you want to export excel file to it an example of the quantity from 3 to 20
Product ID - Condition: There are two boxes for this cell where there are the beginning of the numbers ID or the numbers of the products of the store which have been added ...
As an example to clarify if there is in the first box as an example 123 means that the first product ID number is that number (123), and if the second box as an example 373, this means that the last product ID number is (373) on your store products ,,, also we want to mention that to know the number of products in your store is subtitled the second number 373 from the first number 123 to know the number of products in your store, The number of products in your store is 250 products
Stock Status: inside this box, you can choose the stock status you want to export to the Excel file, which selections includes (in stock, out of stock, pre-order, 2-3 days)
Status: Through this icon, you can choose the status of the products you want to export to excel file where the options include (enabled/disabled)
Export Format: Through this icon the extension of the Excel file and usually chosen XLS
These are the most important fields where you can type the information in it so that you can export it via the excel file on your computer and then update the data and then upload it again via the Import icon
You can use a single cell or a specified box such as price and quantity then export the file to the computer and then update the data then upload it again via the import icon
In case you want to export all the products of your store, choose the appropriate language with you then write the price as an example from 0 to 5000 then quantity as example 1 to 100 then the status then export format XLS,,, then press at the export icon,,,
Next image for illustration
In order to be able to import the product data file excel shit, which was previously exported and update its data please go from the control panel into products then products and then at the top of the page there is an icon called import press at it ,,, the next image for clarification
after clicking on the import icon you will appear with you the page settings which are divided into two parts
Part I: Products
In this section, you can click Choose file button so that you can insert the file on your computer after updating it
then there is import type tap which that contains two optional (model, product ID) if the product data include information about the model or product number you can choose the appropriate with you from this tap
And then choose default from store tap, then choose the language in which the file will be uploaded and inclusion on the store control panel
Note: If selected (Arabic language) from language tap at the Export page is also selected (Arabic language) from language tap at import page and vice versa
After the previous steps are done, then click at the Import icon,,, the next image for clarification
Note: We want to clarify that there is an example excel shit file can work like it on your file and then import on your store again,,, the next picture for clarification
Multiple language products import
You can import your products through an excel sheet in Arabic and in English, so that your customers can purchase the products from the English section and from the Arabic section.
1-We download the example file as shown in the below screenshot, then we fill it with our products.
2-(We keep the product ID column empty in case we upload the products for the 1st time), we have two separate files (English and Arabic).
3- We start with the English file.
4- We pick the (product ID) from product type dropped menu as shown in the below screenshot.
5-We import the English file.
6-We export the file and copy the Productions ID's to paste them in the Arabic file.
7-We import the Arabic file and the store will sync the products with their ID's.
8-In case we need to edit on the products in the future, we export the file and we make our edits. Then we import again without removing the product ID's.
9-We export the file with the same language it has been imported with.
Part II: Product Review
In this part, you can click at Choose file icon so that you can upload the file from your computer after you have previously updated the product Review information on your store,,, the next picture for clarification
Note: We want to clarify that there is an example excel Shit file can work like it on your file and then import it on your store again,,, the next picture for clarification