catalog export / import

[schoolboy]

Simple...

Use Easy Populate to export your product data.

Use Excel to open this file on your local machine.

Insert TWO new columns to the RIGHT of v_products_price column. Lets say these are columns H and I (if v_products_price is Column G).

In the FIRST of the new columns, insert a formula in the second cell (not the header cell) to increase the value of the corresponding v_products_price cell value...

So if the first data cell in v_products_price - lest say it's cell G2 -has the value $10.00, and you want to increase the prices by 5%, then the formula in the new cell (H2) is: =(G2+(G2*0.05)) .

Copy and paste this formula down all cells.

When the ne value shows, highlight the entire column and use CTRL+C to copy it.

Place the cursor in the the I1 cell. Right click. Choose "Paste Special". Click checkbox for VALUES, and click OK. Give column I the heading - v_products_price . DELETE columns G and H.

Save as tab-delimited for EP import into your second store.

[schoolboy]

... or you could import the EP file into your new store as-is, then run a SQL command to update all the prices:

http://www.zen-cart.com/forum/showth...ate+prices+sql

[rajoo.sharma]

Thanks everyone, I've seen such implementation using CRE Loaded. One of my clients has shown me, so it has to be autmatic / interface based. He does not want spreadsheet level or SQL level solution.

I'm still waiting for somebody who has done/used something similar. I'm open for commercial module as well.

Thanks again everyone.
Regards

[lankeeyankee]

have you looked at this? http://www.zen-cart.com/index.php?ma...roducts_id=942

[rajoo.sharma]

Hi lankeeyankee,

The module you suggested is great but unfortunately this is not the one I'm looking for.

I exactly want a catalog export with price hike (entire catalog, category(ies) or specific product(s)) into a CSV file, same as easy populate does and import this into my new store.

The concept is of having a main e-commerce website and several other reseller websites (copy/rep lica of the main, running on different domain and maybe different hosting server), if the reseller wants to sell the products of main website on his website he can export the main website's catalog with price amendment and import in the hsi own (child) website.

So this is a feed kind of work around, but this is what the client wants.

Thanks again for helping me, please suggest if there is any module commercial or open source available that matches my requirement.

Thanks and Regards

[lankeeyankee]

I see now. I am not aware of anything already available, you can post your requirements in the commercial help wanted forum here to receive quotes. It sounds like a modified version of easy populate is what would be the easiest, and cheapest, to implement.

Good luck and please post any modules or developments here so we can all benefit from your experience, it sounds like a good potential module.

[rajoo.sharma]

Hi lankeeyankee,

Thanks again for the reply and the suggestion. If it is not available then I'll write it myself, if I get this project and off course I'll made it available in zen modules as I respect and love the open source community.

I just wanted to save time if something similar is already available as open source (the best option) or even commercial (not too good :-) but suits me).

Thanks and Regards