WordPress.org

Ready to get started?Download WordPress

Forums

Woocommerce CSV importer
Can't Importing Shipping Class ? (18 posts)

  1. merchtone
    Member
    Posted 1 year ago #

    Hey,

    recently downloaded and successfully installed this plugin, works great so far!

    Just a quick question - in terms of the shipping class I have two in my shop:

    Framed Items
    Posters and other merchandise

    Now I went to add a column to my CVS file called shipping_class and added in the words "Posters and other merchandise" in the cell, uploaded all fine and the product was imported but the shipping class in woocommerce is still showing up as "No shipping class"

    Any ideas? Thanks in advance!

    http://wordpress.org/extend/plugins/woocommerce-csvimport/

  2. merchtone
    Member
    Posted 1 year ago #

    I'm doing a cry right now :(

  3. merchtone
    Member
    Posted 1 year ago #

    Can anyone help?

  4. mandothrasher
    Member
    Posted 1 year ago #

    Did you get an answer to this? I'm about to have the same need with an import. Would that be considered a taxonomy? Have you tried naming the column heading like this?

    tax:shipping_class

  5. mandothrasher
    Member
    Posted 1 year ago #

    Just found the answer and tested. This works. If you get to the mapping screen after uploading a file, just click one of the drop downs and you'll see all the available columns names and taxonomies. That's how I found it.

    You column heading should be labeled as follows:

    tax:product_shipping_class

  6. brewrecords
    Member
    Posted 1 year ago #

    hmmm this hasn't worked for me again....I have my shipping class setup as Posters and other merchandise and labelled the colums as the following:

    tax:product_shipping_class
    Posters and other merchandise
    Posters and other merchandise
    Posters and other merchandise
    Posters and other merchandise
    Posters and other merchandise
    Posters and other merchandise
    Posters and other merchandise
    Posters and other merchandise
    Posters and other merchandise
    Posters and other merchandise

    Anything I'm missing?

  7. mandothrasher
    Member
    Posted 1 year ago #

    Are you doing this as a Merge or Import?

  8. mandothrasher
    Member
    Posted 1 year ago #

    Just wondering if the items already exist in the catalog? If so, be sure you're doing a merge and not an import. Otherwise, I think the import skips items that it finds an existing SKU for.

  9. brewrecords
    Member
    Posted 1 year ago #

    Import.

    The products do appear, just when I click on quick edit and look at Shipping Classes none of the tickboxes are selected.

    Very annoying, as it works for my product categories, just not shipping class and this is my last barrier to actually successfully import my products....

  10. mandothrasher
    Member
    Posted 1 year ago #

    Can you post a few lines from your csv file here, including the header?

  11. brewrecords
    Member
    Posted 1 year ago #

    Sure

    title description short_description category stock price regular_price sales_prices weight length width height sku picture tags tax_status tax_class tax:product_shipping_class

    Everything appear fine apart from Shipping Class

    Thank yo for taking the time to help! Appreciated

  12. mandothrasher
    Member
    Posted 1 year ago #

    Here's the first two lines in my data file. If you copy this and paste into a text editor, it will be easier to read. Turn off word wrap if you're using notepad. You'll see the last field is shipping class this product is in the General shipping class that I have setup.

    meta:Manufacturer,post_title,sku,post_content,images,meta:NDCItemCode,regular_price,tax:product_cat,tax:product_shipping_class
    Alere Toxicology,ALERE TOXICOLOGY ISCREEN (DIP CARD) On-site testing. Saves time and money. Simple dip and read procedure. Laboratory accurate. Room temperature storage. Results in minutes. Detects 1-10 drugs. 24-month shelf life.,DOA-454,"Drug Test, 5 Test Dip Device, 25/bx",,INS DOA-454,143,Lab – Point of Care>Rapid Tests,General
  13. brewrecords
    Member
    Posted 1 year ago #

    Sorry that makes little sense to me and is very different from the way my CVS file is setup?

    title description short_description category stock price regular_price sales_prices weight length width height sku picture tags tax_status tax_class product_shipping_class
    Jimi Hendrix 40 x 40 cm 40 x 40 cm Prints 10 4.59 DP0001 http://merchtone.com/shop/Products/Images/Prints_40X40/SC0060.jpg 40 x 40 cm Prints,Jimi Hendrix,Music,Icon,Available in USA Posters and other merchandise

  14. mandothrasher
    Member
    Posted 1 year ago #

    Looks like you're using a tab delimited file format. Have you tried CSV (comma seperated values) format? That's what I'm using. If you've got your data in Excel, choose CSV from the SaveAs dialogue.

  15. brewrecords
    Member
    Posted 1 year ago #

    I am saving it as CVS (Comma delimited) cvs, always have.

  16. mandothrasher
    Member
    Posted 1 year ago #

    You might try doing a merge after your import. In a merge, it looks up the sku and then updates any other fields you include in the file. So, your merge file would only have two columns and look like this:

    sku,tax:product_shipping_class

    fyi...sku should be one of the values you are importing initially.

  17. zigvt85
    Member
    Posted 1 year ago #

    title,description,short_description,category,stock,price,regular_price,sales_prices,weight,length,width,height,sku,picture,tags,tax_status,tax_class,tax_shipping
    Testing Shipping Item,Testing Shipping Item,Testing Shipping Item,Test,1,5,5,,,,,,test01,fake-cover.jpg,,,,Fixed Shipping

    Ok some reason it wont work for me. I have it setup as if i was over writing an old product on the store as in updating. I tried everything and it just will not tick on the shipping method. I have over 100 products and it will take way to much man hrs to turn every one on. Can someone please help me and tell me what I am doing wrong so I can or may fix this problem. I love the script and everything else works find up till now. We do need shipping prices before we open the store.

    Please someone help me and thank in advance.

  18. zigvt85
    Member
    Posted 1 year ago #

    Never mind I figured it out. What you gotta do instead of changing what they are trying to do. Just change taxable to shipping and it should work for you when you import with csv. I'm not sure if all your classes will show up but it works for the single one.

    This is a great plugin support it if you can.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic