How can I import a product's shipping characteristics?

[Knight4]

Hey,

 

I am currently responsible of importing a large number of products to a client's database.

I've been using a CSV file to do this, but so far I haven't been able to correctly determine the shipping characteristics (eg: width, height, depth) of the product itself (Catalog > Products > Edit (Product XPTO > Shipping).

 

Inside the CSV file, I was trying to use:

(...);"Height:9 cm:1, Width:13,7 cm:2";(....)

 

 

and then, I would map this value to the Features (Name:Value:Position) column.

As a result, the product's height and width do appear on the product's datasheet, but so far I haven't managed to copy these values to the shipping tab.

 

How can this be done?

I'm also attaching an example CSV file, should come in handy

 

 

One more thing: what does the "Position" inside the Feature's Name:Value:Position list does? I was using <Feature Name>:<Feature Value>:increment but as far as I can see, this isn't how it's supposed to be done.

 

Thanks in advance!

dummy.txt

Edited October 30, 2012 by Knight4 (see edit history)

[BJC]

Hello,

 

I'm wondering if you were able to solve this and if so, how you did it? I have a store with close to 5000 products and am moving from flat rate shipping to per item and do not want to have to manually enter the shipping dimensions for each product.

 

Thanks!

[Knight4]

Hello,

 

I'm wondering if you were able to solve this and if so, how you did it? I have a store with close to 5000 products and am moving from flat rate shipping to per item and do not want to have to manually enter the shipping dimensions for each product.

 

Thanks!

 

Hi.

I solved it the hard way: SQL inserts to the attributes tables.

It works fine, just remember to run the scripts after importing all the products

 

AFAIK there is no other way to do this.

 

Edit: StackOverflow has proved a better resource. I asked this very question and got a reply after posting a bounty (but hey, at least someone answered).

 

Cheers mate

Edited January 24, 2013 by Knight4 (see edit history)

[BJC]

Thanks!

[gamebreakerz]

I am having the same issue but I don't quite understand the stackoverflow solution. Could you please let me know exactly what you did to solve this problem? Thanks.

[Knight4]

I am having the same issue but I don't quite understand the stackoverflow solution. Could you please let me know exactly what you did to solve this problem? Thanks.

 

Well, first I imported everything as usual (which left the products without their respective dimensions) because there really isn't a viable way to do this with Prestashop.

 

As such, I had to manually update the database. If you fill those fields mentioned in StackOverflow everything works fine.

 

Hope it helps.

[BJC]

I have found a great module that has helped me out. It's called Import Fast (http://prestashop.dataco.dk/en/3-import-fast.html). I only use csv import to update and add to my products and this module contains the width, height, depth and weight fields, which will allow you import this data for each product.

[gamebreakerz]

Well, first I imported everything as usual (which left the products without their respective dimensions) because there really isn't a viable way to do this with Prestashop.

 

As such, I had to manually update the database. If you fill those fields mentioned in StackOverflow everything works fine.

 

Hope it helps.

 

First of all thanks for all of the help/replies. At least I know the forum is working.

 

That is my question. Where do I find the procedure to manually update the database? This is where I am confused. I go to the sql section in prestashop. Copy/paste the code from stackoverflow, and I get a SELECT error. I know there is something simple I don't understand so that is where I'm stuck.

[toninovak66]

You can't run that update in the SQL query manager. You have to have access to your shop's database using either phpMyAdmin, SQL Workbench or some other method depending on your hosting provider. Once you have that you should be able to update the DB based on that post.

 

By the way, I use the import fast module also and it saved me a ton of time importing my whole database of almost 3,000 products, all of which have product combinations. I recommend it to anyone starting out with a large number of products.

Edited May 8, 2013 by toninovak66 (see edit history)

[gamebreakerz]

You can't run that update in the SQL query manager. You have to have access to your shop's database using either phpMyAdmin, SQL Workbench or some other method depending on your hosting provider. Once you have that you should be able to update the DB based on that post.

 

By the way, I use the import fast module also and it saved me a ton of time importing my whole database of almost 3,000 products, all of which have product combinations. I recommend it to anyone starting out with a large number of products.

 

That was the answer that I was looking for. Thanks! I will try this in a couple of hours. I'm trying to do as much as I can on my own first before a start going hog wild with paying for addons.