Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › PowerStore › Powerstore General / Announcements › Fill in database with products

Fill in database with products

Thread began 9/05/2009 1:06 am by andre.mercado338900 | Last modified 9/08/2009 2:44 pm by andre.mercado338900 | 1409 views | 1 replies

9/05/2009 1:06 amandre.mercado338900

Fill in database with products

I download from my distributor 2 different csv or excel (my choosing) files with all the informations for all products:

------ 1st file -----
1.sku
2.upc
3.category
4.subcategory
5.product name
6.headline
7.block copy
8.msrp
9.weight
10.warranty
11.color
12.picture sku
13.requirements
14.package contains
15.in-wall
16.ROHS?
17.new item
18.new item date
19.discontinued
20.redirect
---------------
-------2nd file---------
1.sku
2.product name
3.msrp
4.your cost
5.stock
-----------------------

Im trying to find out how i can populate the tables for powerstore2 using these two files, and when needed update pricing on the products.
i was looking at phpmyadmin which is the only app my hosting will allow to use on the database.
any help would be greatly appreciated.

Andre

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.