Incorrect error at CSV import – No matching product exists to update

Hi there,

The changelog you shared indicates that you’re using the premium https://woocommerce.com/products/product-csv-import-suite/ extension. For more support while using that extension, please open a new support request at https://woocommerce.com/my-account/create-a-ticket/. I’m asking as this forum is only geared towards the core aspects of the WooCommerce plugin itself.

Thanks!

Sorry, my mistake. This link was wrong. Here more details:

Here an example of the current WooCommerce Export CSV file with the related SKUs:

ID,Type,SKU,Name,Published,"Is featured?","Visibility in catalog","Short description",Description,"Date sale price starts","Date sale price ends","Tax status","Tax class","In stock?",Stock,"Low stock amount","Backorders allowed?","Sold individually?","Weight (kg)","Length (cm)","Width (cm)","Height (cm)","Allow customer reviews?","Purchase note","Sale price","Regular price",Categories,Tags,"Shipping class",Images,"Download limit","Download expiry days",Parent,"Grouped products",Upsells,Cross-sells,"External URL","Button text",Position,"Indonesia regular price (IDR)","Indonesia sale price (IDR)","Indonesia date sale price starts","Indonesia date sale price ends","US Dollar regular price (USD)","US Dollar sale price (USD)","US Dollar date sale price starts","US Dollar date sale price ends","Australia New Zealand regular price (AUD)","Australia New Zealand sale price (AUD)","Australia New Zealand date sale price starts","Australia New Zealand date sale price ends","Attribute 1 name","Attribute 1 value(s)","Attribute 1 visible","Attribute 1 global","Attribute 2 name","Attribute 2 value(s)","Attribute 2 visible","Attribute 2 global","Attribute 3 name","Attribute 3 value(s)","Attribute 3 visible","Attribute 3 global","Attribute 4 name","Attribute 4 value(s)","Attribute 4 visible","Attribute 4 global","Attribute 5 name","Attribute 5 value(s)","Attribute 5 visible","Attribute 5 global","Attribute 6 name","Attribute 6 value(s)","Attribute 6 visible","Attribute 6 global","Attribute 7 name","Attribute 7 value(s)","Attribute 7 visible","Attribute 7 global","Attribute 8 name","Attribute 8 value(s)","Attribute 8 visible","Attribute 8 global","Attribute 9 name","Attribute 9 value(s)","Attribute 9 visible","Attribute 9 global","Attribute 10 name","Attribute 10 value(s)","Attribute 10 visible","Attribute 10 global"
123846,variable,ARSDOO-AT,"FUN DOODLE UPPER PRINTED SANDALS",1,0,visible,"<p>Print:FUN DOODLE</p><p>Men flip-flops are an all time summer favorite. Maximum comfort and durable<p>","<p>Composition:100% Rubber</p>",,,none,,1,,,0,0,0,0,0,0,1,,,,Accessories,"ACCESSORIES, FUN DOODLE, MEN",,"https://www.domain.com/wp-content/uploads/2019/09/products-ARSDOO-AT-01.jpg, https://www.domain.com/wp-content/uploads/2019/09/products-ARSDOO-AT-02.jpg, https://www.domain.com/wp-content/uploads/2019/09/products-ARSDOO-AT-03.jpg, https://www.domain.com/wp-content/uploads/2019/09/products-ARSDOO-AT-04.jpg",,,,,,,,,0,,,,,,,,,,,,,Size,"40, 41, 42, 43, 44, 45, 47",1,1,fb_visibility,1,1,1,gallery_sync,1,1,1,,,,,,,,,,,,,,,,,,,,,,,,,,,,
123847,variation,ARSDOO-AT_40,"FUN DOODLE UPPER PRINTED SANDALS - 40",1,0,visible,,,,,none,parent,backorder,0,,0,0,0,0,0,0,1,,,25,,,,,,,ARSDOO-AT,,,,,,0,312500,,,,25,,,,"31,5",,,,Size,40,,1,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
123848,variation,ARSDOO-AT_41,"FUN DOODLE UPPER PRINTED SANDALS - 41",1,0,visible,,,,,none,parent,1,1,,0,0,0,0,0,0,1,,,25,,,,,,,ARSDOO-AT,,,,,,0,312500,,,,25,,,,"31,5",,,,Size,41,,1,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
123849,variation,ARSDOO-AT_42,"FUN DOODLE UPPER PRINTED SANDALS - 42",1,0,visible,,,,,none,parent,1,2,,0,0,0,0,0,0,1,,,25,,,,,,,ARSDOO-AT,,,,,,0,312500,,,,25,,,,"31,5",,,,Size,42,,1,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
123850,variation,ARSDOO-AT_43,"FUN DOODLE UPPER PRINTED SANDALS - 43",1,0,visible,,,,,none,parent,1,3,,0,0,0,0,0,0,1,,,25,,,,,,,ARSDOO-AT,,,,,,0,312500,,,,25,,,,"31,5",,,,Size,43,,1,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
123851,variation,ARSDOO-AT_44,"FUN DOODLE UPPER PRINTED SANDALS - 44",1,0,visible,,,,,none,parent,1,4,,0,0,0,0,0,0,1,,,25,,,,,,,ARSDOO-AT,,,,,,0,312500,,,,25,,,,"31,5",,,,Size,44,,1,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
123852,variation,ARSDOO-AT_45,"FUN DOODLE UPPER PRINTED SANDALS - 45",1,0,visible,,,,,none,parent,1,5,,0,0,0,0,0,0,1,,,25,,,,,,,ARSDOO-AT,,,,,,0,312500,,,,25,,,,"31,5",,,,Size,45,,1,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
123853,variation,ARSDOO-AT_47,"FUN DOODLE UPPER PRINTED SANDALS - 47",1,0,visible,,,,,none,parent,0,0,,0,0,0,0,0,0,1,,,25,,,,,,,ARSDOO-AT,,,,,,0,312500,,,,25,,,,"31,5",,,,Size,47,,1,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
125268,variable,ARSSUS-AT,"SUNSET PALM UPPER PRINTED SANDALS",1,0,visible,"<p>Print:SUNSET PALM</p><p>Men flip-flops are an all time summer favorite. Maximum comfort and durable<p>","<p>Composition:100% Rubber</p>",,,none,,1,,,0,0,0,0,0,0,1,,,,Accessories,"ACCESSORIES, MEN, SUNSET PALM",,"https://www.domain.com/wp-content/uploads/2019/09/products-ARSSUS-AT-01.jpg, https://www.domain.com/wp-content/uploads/2019/09/products-ARSSUS-AT-01.jpg, https://www.domain.com/wp-content/uploads/2019/09/products-ARSSUS-AT-02.jpg, https://www.domain.com/wp-content/uploads/2019/09/products-ARSSUS-AT-03.jpg, https://www.domain.com/wp-content/uploads/2019/09/products-ARSSUS-AT-04.jpg",,,,,,,,,0,,,,,,,,,,,,,Size,"40, 41, 42, 43, 44, 45, 50",1,1,fb_visibility,1,1,1,gallery_sync,1,1,1,,,,,,,,,,,,,,,,,,,,,,,,,,,,
125269,variation,ARSSUS-AT_40,"SUNSET PALM UPPER PRINTED SANDALS - 40",1,0,visible,,,,,none,parent,0,0,,0,0,0,0,0,0,1,,,25,,,,,,,ARSSUS-AT,,,,,,0,312500,,,,25,,,,"31,5",,,,Size,40,,1,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
125270,variation,ARSSUS-AT_41,"SUNSET PALM UPPER PRINTED SANDALS - 41",1,0,visible,,,,,none,parent,1,6,,0,0,0,0,0,0,1,,,25,,,,,,,ARSSUS-AT,,,,,,0,312500,,,,25,,,,"31,5",,,,Size,41,,1,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
125271,variation,ARSSUS-AT_42,"SUNSET PALM UPPER PRINTED SANDALS - 42",1,0,visible,,,,,none,parent,0,0,,0,0,0,0,0,0,1,,,25,,,,,,,ARSSUS-AT,,,,,,0,312500,,,,25,,,,"31,5",,,,Size,42,,1,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
125272,variation,ARSSUS-AT_43,"SUNSET PALM UPPER PRINTED SANDALS - 43",1,0,visible,,,,,none,parent,0,0,,0,0,0,0,0,0,1,,,25,,,,,,,ARSSUS-AT,,,,,,0,312500,,,,25,,,,"31,5",,,,Size,43,,1,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
125273,variation,ARSSUS-AT_44,"SUNSET PALM UPPER PRINTED SANDALS - 44",1,0,visible,,,,,none,parent,0,0,,0,0,0,0,0,0,1,,,25,,,,,,,ARSSUS-AT,,,,,,0,312500,,,,25,,,,"31,5",,,,Size,44,,1,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
125274,variation,ARSSUS-AT_45,"SUNSET PALM UPPER PRINTED SANDALS - 45",1,0,visible,,,,,none,parent,0,0,,0,0,0,0,0,0,1,,,25,,,,,,,ARSSUS-AT,,,,,,0,312500,,,,25,,,,"31,5",,,,Size,45,,1,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
125275,variation,ARSSUS-AT_50,"SUNSET PALM UPPER PRINTED SANDALS - 50",1,0,visible,,,,,none,parent,0,0,,0,0,0,0,0,0,1,,,25,,,,,,,ARSSUS-AT,,,,,,0,312500,,,,25,,,,"31,5",,,,Size,50,,1,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

Here the related import SKU Stock update file with “;”:

SKU;STOCK
ARSDOO-AT_40;0
ARSDOO-AT_41;1
ARSDOO-AT_42;2
ARSDOO-AT_43;3
ARSDOO-AT_44;4
ARSDOO-AT_45;5
ARSDOO-AT_47;0
ARSSUS-AT_40;0
ARSSUS-AT_41;6
ARSSUS-AT_42;7
ARSSUS-AT_43;8
ARSSUS-AT_44;9
ARSSUS-AT_45;0

Please advise why the SKU Stuck update file generate this errors and SKUs are not getting updated:

SKU ARSDOO-AT_47	No matching product exists to update.
SKU ARSSUS-AT_40	No matching product exists to update.
SKU ARSSUS-AT_42	No matching product exists to update.
SKU ARSSUS-AT_43	No matching product exists to update.
SKU ARSSUS-AT_44	No matching product exists to update.
SKU ARSSUS-AT_45	No matching product exists to update.

Hi @pakkriss,

Can you confirm if you’re using the Product CSV Import Suite plugin to export/import content from your WooCommerce installation?

If you are using Product CSV Import Suite you can contact support for that product from this page of your WooCommerce.com customer account.

https://woocommerce.com/my-account/create-a-ticket/

If you’re not using the Product CSV Import Suite plugin can you please reply letting us know which method you’re using for importing and reporting products.

I don’t use the plugin you mentioned.

I use WooCommerce standard Import Export available at Products List page, which works usually very well

Hope this helps

Running the import with the data below then all is good.

Question left is why the SKU is not recognized anymore during the import, even if exist.

ID;In stock?;Stock
123846;1;
123847;0;0
123848;1;1
123849;1;2
123850;1;3
123851;1;4
123852;1;5
123853;0;0
125268;1;
125269;0;0
125270;1;6
125271;1;7
125272;1;8
125273;1;9
125274;1;10
125275;0;0

@stuartduff @riaanknoetze is this topic still on your radar?