Can't Importing Shipping Class ?

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 https://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.