1. Knowledge Base
  2. Products and Badges

retraced Product Sheet Guide

Conveniently create, upload, and update products in bulk using the retraced Product Sheet

Creating and updating products are notably tedious tasks if you do it one by one. But we have a great news! You can now upload your Shopify Product csv Export or use our very own retraced Product Sheet to create and update products in bulk hassle free! 👍🏻

 

Here is some guidance for using the retraced Product Sheet:

  1. Each row MUST have a product handle.

  2. Informative: For general product information, only the first row of the product's information is taken into consideration. Other rows just require the same handle.

  3. Informative/Suggestion: Input one SKU per row.

  4. Informative: If SKUs are left empty for new products, none will be inputted for the product. If SKUs are removed from the sheet or left empty for existing products, they will be removed from the retraced dashboard as well.

  5. Informative: If any information is uploaded via the template with the same handle (on the platform as “product code”) as an existing product on the platform, it will overwrite the existing data for that product.
  6. Informative: If a product handle is removed, it is left untouched on the retraced dashboard.

  7. Informative: retraced product sheet headers must have original parenthesis preserved.

Which columns are case-sensitive?

The following columns are case-sensitive but not mandatory, meaning they can be left empty and the upload will still be successful. Should you want to input values into these columns, please type them in the following pre-defined ways:

1. Column E - Gender

MALE, FEMALE, UNISEX

2. Column F - Apparel category

BLOUSE, CARDIGAN, JUMPSUIT, TOP, SHIRT, T_SHIRT, DRESS, SWEATER, SWEATSHIRT, COAT_JACKET_BLAZER, PANTS, JEANS, SKIRT, SHORTS, SHOE, SOCKS, SCARF, HEADWEAR, SWIMWEAR, UNDERWEAR, BAG, JEWELRY, BELT, TIE

3. Column G - Material name

Piñatex
VEGEA 110
Copper
Bronze
Ingeo
Cotton bale
Polyacryl (acrylic fibers)
Post-consumer recycled Polyester
Brass
Modal
Ramie
Regenerated Cellulose / Rayon
Leather
Llama wool
Polyurethane
Recycled Polyurethane
Elephant Grass 
Olefin fiber
Platinum
CiCLO
Lotus silk 
Tule
Wool
14k White Gold
Milliner Organic
Peace Silk
Tungsten
ECONYL®
EcoPaXX
Euroflax Linen
EcoVero™ Viscose
Vegetable Tanned Leather
Titanium
REPREVE®
Viscose
Hemp
Stainless Steel
14k Palladium
MCI Cotton
Alpaca Wool
Ceramic
LYCRA® T400® ECOMADE 
Micromodal
Pre-consumer recycled Polyester
EVA
SeaCell®
10k Yellow Gold
COOLMAX®
Cotton
Recycled Nylon
Thermoplastic polyurethane
18k Rose Gold
Cork
Wild Silk
Sea Silk
PVC
Recycled Wool
Linen
Kapok
Natural Rubber
14k Rose Gold
Lurex
QMILK
Fur
Recycled Polyamide
Lycra
Elastane/Spandex
14k Yellow Gold
Barkcloth
Merino Wool
Polyester
Recycled Polyester
Vicuña Wool
Calotropis pod fibers
Bio-based Polyurethan
Recycled EVA
Nylon
10k Rose Gold
Camel hair
Banana fibre
Silk
Rush
Teflon
Coir
Post-consumer recycled Cotton
Organic Cotton
Cashmere
Chromium Tanned Leather
Lyocell
Silicone
10k White Gold
Mycelium
VEOCEL™
Synthetic rubber
SEAQUAL® YARN
Pre-consumer recycled Cotton
Coffee fabric
Nettle
Recycled Cotton
TENCEL™
Down
Acetate
ROICA™
Polypropylene
CR-39
Silver
Cupro
Refibra™
Aluminium
18k Yellow Gold
18k White Gold
Sisal
Mohair
Qiviut
Recycled Synthetic Rubber
Recycled Elastane
Angora
Bamboo fiber
Jute
Polyamide