WordPress.org

Support

Support » Plugins and Hacks » Can't Importing Shipping Class ?

Can't Importing Shipping Class ?

  • 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/

Viewing 15 replies - 1 through 15 (of 17 total)
  • I’m doing a cry right now 🙁

    Can anyone help?

    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

    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

    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?

    Are you doing this as a Merge or Import?

    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.

    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….

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

    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

    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

    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

    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.

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

    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.

Viewing 15 replies - 1 through 15 (of 17 total)
  • The topic ‘Can't Importing Shipping Class ?’ is closed to new replies.