fesh.store

Bulk data update

Bulk update process:

Step 1:  Export data to XLSX spreadsheet file

Step 2:  After you make changes, import the file to your store:

  1. Go to Catalog - Import/Export and choose an Advanced import option
  2. Choose import type - update all data or delete all old data before Import

    Before product import, you have to create or import all store catalog structures - categories, product variants, and technical attributes and only after that, you can import products. fesh. will create all non-existent categories, but the best practice is to create all catalog structures before the products import

  3.  Click Choose file and select the import file from your computer
  4.  Press Import button


Product import required fields:

Most import file fields are optional, but some of them are required:

Product id - you can type any product ids, like 1,2,3,4,5... but only in ascending order! If a product with this ID already exists - the product data will be updated

Name - type product name

Categories  - you can type category id from Catalog - Categories or category name.

  •     You can assign products to several categories. Type categories comma separated - category 1, category 2, category 3
  •     You can create and assign subcategories - use the symbol ">": main category > subcategory 

SKU - type product SKU

Quantity - type product quantity. You can subtract product quantity after order or not. Type true to subtract or false on the subtract filed

Image_name - You can import product images in two ways:

  1. Just add the URL of the image from another site to image cells and fesh. will automatically download the image and assign it to the product
  2. Previously upload images via image manager and type image path  
  3. You can assign unlimited additional images in the AdditionalImages tab

Shipping - the product requires shipping - yes or no

Price- type product price in your store's main currency

Status - true or false. Is the product is available for order or not

tax_class_id- by default, 9

Description- product description. You can use HTML tags

stock_status_id - the product requires shipping - yes or no

store_ids - if you have only one store in your account - type 0. You can assign the same product to several stores - type comma-separated store ids

minimum- minimum order amount. you can type 1