Get help with Shoplo products

Importing products from CSV


Go to Products > Click on the three dots > Select ‘Import products from CSV’.

Steps when importing products:


Preparing and uploading your CSV file

Click on Upload a file.

The file should be prepared as follows:

  • Use UTF-8 encoding
  • Use a comma (,) as s field separator
  • Use quotation marks (“) as a text separator

Register categories:

Use the text separator (“) to register a category and add the following categories after a comma.

(…), “Men, Women, accessories, extras,” (…)

Subcategories are added using the “>” sign.

“Men> Shirts> Long Sleeve”, (…)

Example (Men’s Shirt):

Belongs to the categories:

  • Men> Shirt
  • Special products

Let’s assume that there are only two columns in the CSV file: title and category

The file will look like this:

Title, Category
Men’s shirt, “Men > Shirt, Special product”


What to keep in mind when updating product data?

If you use the import from a CSV file to update product data on your store, there are a few things to keep in mind:

Don’t change URLs

During the import, products are “recognized” by the URL address. Remember always to map this column and do not change the URLs in the CSV file.

If you want to change the URL, do it from the store’s panel. For the next import, make sure that the CSV file has a new URL. Otherwise, the product will be added again.

Update of variants and parameters

Just as the URL recognizes products, the same way product variants are identified by Stock Keeping Unit (SKU). This means that you can not update SKUs before the import.

If you change the SKU, the current variant will be removed, and a new one will be added.

Select the appropriate checkbox if you want to update the data

If you’re going to update, for example, stock levels or product price by importing a new CSV file, select “Overwrite the existing products which have the same variables”.

Leaving this box cleared, you will only upload new products that are not yet on the store. Other changes will be ignored.

Data update

When updating products, select the appropriate columns:

  • URL
  • SKU
  • all parameters
  • additionally, select the ones you want to update as the price or inventory

If you are not adding or updating photos, don’t map these columns.

Changes and removal of variants

By updating data by CSV import, you can delete selected variants. Simply remove them from the CSV file in the selected product and then import the data file.


Matching the right columns (mapping)

Match your CSV file columns to the columns from Shoplo. Remember to tick all the columns that you need.

Depending on the number of products, the import can take several minutes.


Troubleshooting

What if the CSV file doesn’t import?

If the file doesn’t import your products correctly, it might mean a few things:

  • The file is saved in the wrong format
  • Several products have the same SKU
  • There are empty fields in the SKU column
  • Something is not working well – Please write to us and we will help you.
  • Etsy CSV files may have problems.  If you’re trying to import an Etsy CSV, please contact us.

Was this article helpful?

Still can’t find what you’re looking for?

Contact us
Team