Support » Plugin: WooCommerce » Regarding bulk uploading products having variations using CSV files

  • We are trying to upload products using the csv files that are having different variations, but when we import csv we did not get the expected result.

    We have drop down list for screw length shows all of the possibilities for all of the screw gauges, it should only show the lengths that are available for a particular gauge size group. For example a zero gauge screw should show three possible lengths (¼”, 3/8” and ½”) in the drop down list for screw length.but when we try to upload products in bulk by using csv we are getting all the screw options in the drop down.

    when we upload product manually with the same variations we are getting the expected result but when we try to upload csv as we have lot of products to add,we are not getting the expected result.we are getting all the options in the dropdown instead of purticular options.

    We have add a limited number of variable products using this method then exported them as a CSV file so that we know the CSV format and then we can create CSV like that and then import. We found that inputting a small number of variable products with limited variations via a CSV file worked, but when inputting a large number of variable products using a CSV file it did not work.

    We have provides link of our page where we have select the 0g option and instead of getting 3 options for that we are getting all the options in the dropdown for 0g.

    Please can you help us with this is there anything we are missing.

    Waiting for your reply.

    The page I need help with: [log in to see the link]

Viewing 13 replies - 16 through 28 (of 28 total)
  • Plugin Author Ron Rennick

    (@wpmuguru)

    > The 3g and 4g and 5g variations did not show up in the user view but are in the database, as you can see in the exported data.

    @fordtman You have set default variation in the edit screen. Click Clear when viewing the product then you will be able to select any variation.

    Ron, Thanks for the reply, I appologise for taking so long to get back to you, a few other problems got in the road.

    It was a misunderstanding on my part, I was assuming the default value applied to all of the variation and showing the default was a nice way of showing the customer the type of values to expect in the fields as well as setting a base selection for all the products. However I am now back to the original problem I had when I first started importing products.

    In the folder: https://www.transfernow.net/fkToWg122020 there are two imports, one for 31 products and another for 32 products. The 31 product import works but the 32 product import doesn’t (see the videos). Can you tell me if there is a setting that determines the number of variations that are allowed or is it a “size if data” matter. 31 or 32 products to me does not seem to present much of a problem.

    Plugin Author Ron Rennick

    (@wpmuguru)

    The 31 product import works but the 32 product import doesn’t (see the videos).

    The second file is 33 lines

    • 1 x Header row
    • 1 x Variable product record
    • 31 x variations

    It imports correctly for me creating the variable product with 31 variations.

    Hi Ron, did you use the file “wc-product-import-test5.csv” I sent to test for your result? I have just deleted and re-imported these products and still have the same error as shown in the file “Using input-test5.mp4” I sent (files were in https://www.transfernow.net/fkToWg122020). If you did not use my file could you please send me an exported copy of the data you were using or, if you did use my file could you tell me the version of Woocommerce you are using. Also have you modified your Woocommerce .PHP files to accept a larger number of variations?

    Plugin Author Ron Rennick

    (@wpmuguru)

    did you use the file “wc-product-import-test5.csv” I sent to test for your result?

    Yes, and it imported fine for me. Only WooCommerce and Twenty Nineteen was active.

    Thread Starter demon09876

    (@demon09876)

    @wpmuguru

    We have upload the “wc-product-import-test4.csv” and we get the result that we want,(you can see that in the website https://www.goodsandchattels.com/newgood/product/brass-countersunk-screws/ ) but when we upload the “wc-product-import-test5.csv ” then we are not getting the same result. We have also increase the max limit of variations.But still we are not getting the expected result by uploading the “wc-product-import-test5.csv “. Can you please help us if there is any setting we need to do from back-end so that we can get the result.

    Why it work for “wc-product-import-test4.csv” and not for “wc-product-import-test5.csv “?

    • This reply was modified 1 year, 7 months ago by demon09876.
    Plugin Author Ron Rennick

    (@wpmuguru)

    The 31 product import works but the 32 product import doesn’t (see the videos).

    But still we are not getting the expected result by uploading the “wc-product-import-test5.csv “.

    It looks like you are expecting 32 variations to be imported but the test5 file only has 31 variations in it.

    Can you please help us if there is any setting we need to do from back-end so that we can get the result.

    I used a new install with minimal setup to do the import test above.

    We have also increase the max limit of variations.

    Can you describe where you found this setting?

    Thread Starter demon09876

    (@demon09876)

    Hello,

    We have increase the max size by adding one line code in function.php file.

    define(‘WC_MAX_LINKED_VARIATIONS’, 100);

    reference link : https://ideas.woocommerce.com/forums/133476-woocommerce/suggestions/2915157-increase-max-of-variations

    • This reply was modified 1 year, 6 months ago by demon09876.
    Plugin Author Ron Rennick

    (@wpmuguru)

    Your test file only has 31 variations which is less than the 50 described in that thread. Aside from that, the constant applies to the Create Variations from All Attributes button in the product edit screen vs the product import.

    Plugin Support Ena P (a11n)

    (@drwpcom)

    Hi @demon09876. We haven’t heard from you in a while so I’m going to go ahead and mark this thread as resolved. If you still need help with this issue or have any other questions about the WooCommerce plugin, please start a new thread.

    Thread Starter demon09876

    (@demon09876)

    Hello @wpmuguru , the issue is still there if you import the test4.csv file in the website it shows the expected result as it has 30 variations but when we add one more variation from backend i.e. from product page and update it the result gets change please tell us why it is happening,when we add more than 30 variation.
    We have check this with the basic wordpress theme Twenty Nineteen and WooCommerce was active.

    Please help us in this.

    Thread Starter demon09876

    (@demon09876)

    Please resolve this issue as we are not getting the expected result after uploading the csv file having more than 30 variations.

    Plugin Author Ron Rennick

    (@wpmuguru)

    @demon09876 This thread was closed. You will need to start a new thread. It looks like your issue isn’t related to the import but an unexpected limit on the number of variations. When you create the new thread describe the details around that.

Viewing 13 replies - 16 through 28 (of 28 total)
  • The topic ‘Regarding bulk uploading products having variations using CSV files’ is closed to new replies.