Quote:
Originally Posted by emmanuelle
the photos are named to correspond to the item number
|
You?re in great shape. I congratulate you on being organized. This should be pretty easy to do.
I would export the products data to a CSV file and use the concatenate function to update the ?Products Image? field. For example, if column A is your ?Products Model? or "item number" filed and column E is your ?Products Image? filed. Enter the formula ?=CONCATENATE(A1,".jpg")? in cell E1. Highlight cell E1 and drag the handle to cell E15000 (the last row). Thereafter, import the products data back into Zen Cart and you?re done.
If you?re super organized, you may have the manufacturer as part of the image path. You will need include the path in the concatenate expression, i.e. =CONCATENATE(?foldername/?,A1,".jpg")?
If you don?t feel comfortable doing the exports and imports, check out
Store Manager for Zen Cart. It will easily do the export and import as well as allow you to manage Zen Cart from your desktop without having to go into the admin area. With so many products, you probably should have it.