Variable Products Not Uploading Correctly

Resolved mojodesignco
(@mojodesignco)

11 months, 3 weeks 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)

11 months, 3 weeks 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)

11 months, 3 weeks ago

Thanks how can I share the file with you

smackdevsupport
(@smackmarketing)

11 months, 3 weeks ago

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

Thread Starter mojodesignco
(@mojodesignco)

11 months, 3 weeks 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)

11 months, 2 weeks ago

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

smackdevsupport
(@smackmarketing)

11 months, 2 weeks 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)

11 months, 2 weeks 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)

11 months, 2 weeks 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)

11 months, 2 weeks 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)

11 months, 2 weeks 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)

11 months, 2 weeks ago

Did you also look into the SKU issue?

smackdevsupport
(@smackmarketing)

11 months, 1 week 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