Skip to main content

Bulk Edit Products

Find out how to edit your products quickly in bulk.

Updated over 10 months ago

To bulk edit existing product information, tap then Export Products to export product information.

Important: Not all exported data can be edited and re-imported. The remaining data is to provide context about each product. The first column displays the RowType; either Product or Variant. For Product lines the following data can be edited:

  • SKU

  • Name

  • Category

  • Sub-category

  • Supplier

  • Brand

  • TaxCode - S = 20%, Z = 0% as setup under settings > tax rates. An existing tax rate must be setup in the back office, prior to adding to the spreadsheet

  • Archive (and unarchive) - Y to archive. If a product is already archived, a Y will be displayed, to unarchive, remove the Y so the column in blank or add a N.

  • Tags - separate with a space, pipe, space " | " if multiple

eCommerce specific columns

  • Meta title - Ideal length 50–60 characters

  • Meta description - Ideal length 155–160 characters

  • Google Taxonomy - Use this list, to find the taxonomy ID related to the product.

    • πŸ’‘ Tip: Press ctrl + F to display the search bar and type a a generic term to help find the most appropriate category. For instance, search cycling to highlight all cycling related products

  • Gender (apparel products only) - Case sensitive, must be:

    • male

    • female

    • unisex

  • Age (apparel products only) - Case sensitive, must be:

    • newborn = Newborn (0–3 months)

    • infant = Infant (3–12 months)

    • toddler = Toddler (1–5 years)

    • kids = Children (5–13 years)

    • adult = Adult (13 years+)

  • Publish - Y to publish. Blank if not published. If already published, the field will display a Y, to unpublish, change the cell to blank or add a N

  • ISPO (In-store purchase only) - Same as publish above

  • OOSP (Out of stock purchase) - Same as publish above

  • Badges - separate with a space, pipe, space " | " if multiple

For Variant lines, the following data can be edited:

  • SKU

  • Model no.

  • Barcode 1

  • Barcode 2

  • CostPrice

  • Weight

  • Length

  • Width

  • Height

eCommerce specific columns

  • GTIN

  • UPC

  • EAN

  • Surcharge

  • CollectOnly - Same as publish above

Once the products have been updated in the CSV document, the products can be re-imported and updated. Tap then Import to import the changes.

Did this answer your question?