I need a bot making that will input data from a spreadsheet into Etsy and make listings.
A video of the Etsy screen has been attached so you can see how it works.
Below are the fields that need to be entered and where the data will come from.
Photos URL's will be provided
Title From sheet
About this listing Default values
Category From sheet - once pasted it asks you to select one in which we will select 1st one
Craft type select all
Material From sheet
Primary colour From sheet
Secondary colour From sheet
Set From sheet
Occasion From sheet
Celebration From sheet
Renewal Options From sheet
Type From sheet
Description Will be a combination of 4 cells on new lines.
Section From sheet
Tags From sheet
Materials From sheet
Price From sheet
Quantity From sheet
SKU From sheet
Variations "Variations are the most complex part. Variations button after being clicked will bring up another box where you have to enter variation data including the variation group name and the individual variants (e.g. a tshirt would have Colour and Size). The 3 tickboxes also have to be selected and after clicking update, it will take you to back to the original screen with the variants all filled in.
The SKU, Price and Quantity of each one will now have to be filled in from the csv.
Personalisation From sheet
Shipping From sheet
Publish! Publish!
Attached also is a snippet of product information which would need to basically go into Etsy.
Note. The SKU's ending in -P are the parent producst and the same SKU with a number at the end are its variations. VAR1 and VAR2 columns contain the variation data of the product.
Some products have one variation (such as Colour only) and others have two (like Colour and Type).
Sku's ending in -S are standalone items which have no variations.
If you think you're able to do this please get in contact with a price
A video of the Etsy screen has been attached so you can see how it works.
Below are the fields that need to be entered and where the data will come from.
Photos URL's will be provided
Title From sheet
About this listing Default values
Category From sheet - once pasted it asks you to select one in which we will select 1st one
Craft type select all
Material From sheet
Primary colour From sheet
Secondary colour From sheet
Set From sheet
Occasion From sheet
Celebration From sheet
Renewal Options From sheet
Type From sheet
Description Will be a combination of 4 cells on new lines.
Section From sheet
Tags From sheet
Materials From sheet
Price From sheet
Quantity From sheet
SKU From sheet
Variations "Variations are the most complex part. Variations button after being clicked will bring up another box where you have to enter variation data including the variation group name and the individual variants (e.g. a tshirt would have Colour and Size). The 3 tickboxes also have to be selected and after clicking update, it will take you to back to the original screen with the variants all filled in.
The SKU, Price and Quantity of each one will now have to be filled in from the csv.
Personalisation From sheet
Shipping From sheet
Publish! Publish!
Attached also is a snippet of product information which would need to basically go into Etsy.
Note. The SKU's ending in -P are the parent producst and the same SKU with a number at the end are its variations. VAR1 and VAR2 columns contain the variation data of the product.
Some products have one variation (such as Colour only) and others have two (like Colour and Type).
Sku's ending in -S are standalone items which have no variations.
If you think you're able to do this please get in contact with a price
