Tutorial on Product CSV Import & Export (BPE) – Hextom

Our CSV Import and Export functions will allow you to edit your products by exporting your product details to a CSV, as well as allowing you to edit your products by importing a CSV.

CSV Importing

1. Choose to edit products, or add new ones.

The first step for our CSV importing function would be to choose to either edit already existing products, or to add new ones on your store. You can choose either of options by clicking on the corresponding button in step 1.

2. Upload your spreadsheet

You can upload your spreadsheet to our app using 3 methods. You can upload it from your device, provide a spreadsheet URL, or provide an FTP location.

If you are submitting a spreadsheet URL, you will need to ensure that the URL provided points directly to the sheet. If you are uploading a sheet from Google Sheets, we have a short guide on how to do that, which you can find here.

If you are submitting an FTP location, you will need to ensure that the FTP location is in the format ftp://user:password@your.ftp-server.com/path/to/file.xlsx

Once you have everything set, you can click the "upload" button to proceed.

Please note that the only accepted file formats for this function are CSV and XLSX files. Any other file formats are not accepted in our app.

3. Map the columns

Once the sheet is uploaded, you can begin to map the columns. For example, in my task below, the product title is in column 1. I am using the product title as the field that the app should search by, so I have mapped the title to column 1. The price and the SKU are in columns 2 and 3 respectively, so I have also mapped them to their corresponding columns in the app.

Once you have finished the mapping, you can then click the "Start CSV Import Now" button at the bottom of the page.

Avoid Duplication?

If you are adding new products, you may notice an "Avoid duplication" checkbox next to some fields. We have a short guide on this function, which you can find here.

CSV Exporting

1. Set up the product filter

The first step to setting up a bulk edit is to set up the filters. Our app has many fields that you can filter from, which can help you narrow down the products that you would like our app to edit. Our app also comes with a preview function, so that you can verify if the products found are correct.

2. Choose the fields to export

You can select the fields that you want our app to export from the dropdowns. Product ID is always included in any export in the first column, and if any variant fields are included, the Variant ID will be included as well in the second column.

Optional step

You can adjust the export settings using the fields below. You can control the file name and file format of the exported file, as well as email the file or upload it to an FTP server by providing the appropriate details.