Saledock

To bulk edit existing product information, tap<img src="https://downloads.intercomcdn.com/i/o/996924572/62af8553c14f746395055690/image.png" width="23" alt=""> 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:

TaxCode - S = 20%, Z = 0% as setup under settings &gt; 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

- SKU
- Name
- Category
- Sub-category
- Supplier
- Brand
- TaxCode - S = 20%, Z = 0% as setup under settings &gt; 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

Meta title - Ideal length 50–60 characters

Meta description - Ideal length 155–160 characters

Google Taxonomy - Use this <a href="https://www.google.com/basepages/producttype/taxonomy-with-ids.en-GB.txt" target="_blank" rel="nofollow noopener noreferrer">list</a>, 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

- Meta title - Ideal length 50–60 characters
- Meta description - Ideal length 155–160 characters
- Google Taxonomy - Use this <a href="https://www.google.com/basepages/producttype/taxonomy-with-ids.en-GB.txt" target="_blank" rel="nofollow noopener noreferrer">list</a>, 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

CollectOnly - Same as publish above

- 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 <img src="https://downloads.intercomcdn.com/i/o/996924572/62af8553c14f746395055690/image.png" width="" alt="">then Import to import the changes.