Home » Forums » Ubercart » Support

Updating en masse

Submitted by doomed@drupal.org on Mon, 11/17/2008 - 18:23
doomed@drupal.org
Posts: 143
 Joined: 04/05/2008
Bug Finder

Hello,

We've all seen how to import new data from a CSV file. It works quite well.

My question today is how to use the same scheme (CSV file) to update stuff.

Let's say i have in my store 1000 products with all information in there (Name, sku, prices). Everything except photos.

But later i want to add the photos, so i create a new CSV file with two columns:

Column1: SKU
Column2: Image file

And then all the data.

How can i use this file to update all my products with their new photos?
permalink #1 Tue, 11/18/2008 - 01:51
zeezhao
Posts: 116
 Joined: 04/23/2008

If you understand the structure of the tables, you can also write a simple sql query to update the data directly in the database. Relevant tables include: files, content_field_image_cache, sequence, etc.

The node_import used on the forum also has a patch somewhere to update nodes. Check these links:

http://www.ubercart.org/contrib/5221

http://drupal.org/node/150397