Convert product data for different software
$30-250 USD
Płatność przy odbiorze
Reformat these spreadsheets and fill in the missing data. There are 7 product sheets (attached). Return file in Excel 2003 format. I expect at least 99.5% accuracy.
Directions:
Each file has examples of how things should be set
The configurable attributes are based on the content listed in “variation_key” column. If “variation_key” column is empty, no Child products need to be created.
Each item that has configurable attributes needs a Parent and Child products
Child products are products that have configurable attributes
Only the column described below need to be changed
_________________________________________________________
sku
Needs to be unique for each item
Add dash and attribute at the end of the code (no spaces) – this is only for configurable products
name
Needs to be unique for each item
Add comma and attribute at the end of the name
_type
Parent product – set as configurable
Child product – set as simple
If there is no child products, the _type should be set as simple
_attribute_set
Should be the same for each excel sheet
If there is no child products, this column can be left empty
config_attributes
List out the attributes used.
Separate using commas.
No spaces
If there is no child products, this column can be left empty
Attributes
These differ on each file: size, colour, bra_size etc
configurable
The list of the child product’s sku
Separate using commas.
No spaces
If there is no child products, this column can be left empty
tax_class
Set to 2
variation_sku
This is exactly the same as the child product’s sku
Parent product doesn’t need variation sku
If there is no child products, this column can be left empty
status
Set to 1
visibility
Parent product – set to 4
Child product – set to 1
If there is no child products – set to 4
Numer ID Projektu: #4629678
O projekcie
17 freelancerów złożyło ofertę za $130 w tym projekcie
Hi, I have gone through your requirement and I am glad that I am best fit in your requirement , Please give me opportunity to work with you. Please check PM . Thanks,
As a Research Associate for more than three years now, I can process this post with accuracy.