Variable Products Not Uploading Correctly

Resolved mojodesignco
(@mojodesignco)

1 year ago

Having trouble with uploading my variable products. I am using the provided Woocommerce import template which works when uploading my simple and variable products. I however have two ACF fields I needed to map so I want to use this plugin to import my product data with those 2 custom acf fields. However this works for the simple products but not creating the variable products. It adds them as attributes but not as variations.
I don’t want to have to create a whole new spreadsheet so would love to work out to to map my current spreadsheet to allow for those variations to populate correctly in the variable products.

Viewing 12 replies - 1 through 12 (of 12 total)

smackdevsupport
(@smackmarketing)

1 year ago

@mojodesignco Could you please share the ACF field detail/setup and the sample CSV used for variation import? We will check this locally and confirm.

Thread Starter mojodesignco
(@mojodesignco)

1 year ago

Thanks how can I share the file with you

smackdevsupport
(@smackmarketing)

1 year ago

@mojodesignco Please share sample CSV and ACF setup in Google drive and provide access to [email protected]

Thread Starter mojodesignco
(@mojodesignco)

1 year ago

not a problem I have shared with that email and see here:https://drive.google.com/file/d/1oEYU28kvXjRD1HB7Lx5jDk1n6qsYP4aE/view?usp=sharing

THE ACF setup is for Specifications and Care & Maintenance coloumns. See below screenshot of the field groups.

Thread Starter mojodesignco
(@mojodesignco)

1 year ago

Sorry here is the ACF setup https://drive.google.com/file/d/1ruL7138iFKFLWwI9KbyWbF2jXyegENok/view?usp=sharing

smackdevsupport
(@smackmarketing)

1 year ago

Hi @mojodesignco We tested the Variable import using your ACF setup, and modified some values in your CSV. Now its working fine.

In your CSV, The Variation SKU and Parent is not assigned properly.
Attaching the working video https://drive.google.com/file/d/1RKnhferfLg0VoQL2cTchbROWIBp65oLR/view

Modified CSV https://www.dropbox.com/scl/fi/ow7m1el167lu9af87y7kj/2025-06-11__Webstore__import_file_NEW_2_-_2025-06-11__Webstore__import_file_NEW_2.csv?rlkey=l2mpvjzvx7f0xm38h68mvnqrs&st=ssnn249t&dl=1

Thread Starter mojodesignco
(@mojodesignco)

1 year ago

Thank you that is great, however I need to map more fields, eg the price, weight, length, height, stock, tax etc. all the fields with data and when I did this it still doesn’t work? The variations are not created only the attributes.

smackdevsupport
(@smackmarketing)

1 year ago

@mojodesignco We have tested with extra fields like price, weight, length, height, stock. Here please check this

Get the tested CSV from here. If you are still having difficulty, it might be an incorrect CSV format. So please share your Import process video and used CSV.

Thread Starter mojodesignco
(@mojodesignco)

1 year ago

Thank you for testing again. However I can see in your video the description doesn’t import as well as the individual variable product SKU’s which are in my spreadsheet and are required? Are you able to check this for me please.

smackdevsupport
(@smackmarketing)

1 year ago

@mojodesignco We have fixed the description issue. Thanks for pointing this to us. This is not an issue with Import Export Suite for CSV and XML Datafeed We have added a fix in WooCommerce add on pack. That will be updated in the next release. As of now, our team has shared the fixed pack with you via email. please update that pack and check once

Thread Starter mojodesignco
(@mojodesignco)

12 months ago

Did you also look into the SKU issue?

smackdevsupport
(@smackmarketing)

12 months ago

Variation SKU also gets imports https://drive.google.com/file/d/1hrExxpRPSxpI9OLqgwGg6k9QJSczrJw9/view
Please note that the Product SKU is mandatory for WooCommerce Product import and not the Variation SKU. So please make sure you have a value for Product SKU and Map while importing. Hope this helps you.

Viewing 12 replies - 1 through 12 (of 12 total)

The topic ‘Variable Products Not Uploading Correctly’ is closed to new replies.

Tags