HomeHome Product Discus... Product Discus...SmithCartSmithCartAll shipping methods require a product to have a weight.All shipping methods require a product to have a weight.
Previous
 
Next
New Post
12/10/2012 12:45 PM
 
Hello,

I've been messing around with some different shipping options in my store's cart, and I have come to find that in order for any shipping method to work, the product must have a weight.

Not knowing this simple fact while doing my imports, I gave many products a weight of "0" knowing that I would not need this information on my cart. I have now come to find that this was unwise, as it is required for any shipping method to work.

I would be happy to simply export my products, and re-import them with a value in the weight column. However, I have found that the product export function of the cart is a bit buggy when it comes to the product categories. The exported categories are showing truncated values in the excel spreadsheet.
An example of this would be:

Imported values in category column for a product:
6-string-electric-guitars;6-string-electric-guitar-brands~squier-6seg;squier-affinity-6s

Example exported values for the same product:
6-string-electric-guitars;6-string-electric-guitar-brands~squier-6seg;squier-affinity-6
6-string-electric-guitars;6-string-electric-guitar-brands~squier-6seg;;squier-affinity-6s


As you can see, sometimes a product category has the last letter truncated. Sometimes, a random extra ";" is added to the category values. When I did my complete store reload, this was acceptable, as I was re-creating the categories anyways. However, If I miss any one of these truncated values, it will create a new category, and my menu will not recognize it.

Any suggestions on how to tackle this issue?

Thanks - Alex
 
New Post
12/10/2012 4:53 PM
 
HI Alex,

As a possible solution t update your Products weight without importing again you could run a SQL script to update the weight field in your database.

The following should do the trick for you, be sure to make a backup of your database in case you need to rollback:

UPDATE Smith_Products SET Weight =(NewNumber) WHERE Weight=(OldNumber)

Please let us know is this solutions resolves this issue.

Thnaks.
 
New Post
12/11/2012 1:39 PM
 
Yes Kevin. This solution works perfectly.

It allows me to keep the current weight value on products which I have added one, and updates the ones with a zero value to have a weight.

Problem Solved!

Thanks!
 
New Post
12/14/2012 1:47 AM
 
Always glad to help!
 
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartAll shipping methods require a product to have a weight.All shipping methods require a product to have a weight.