close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 or 2018 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Bulk Uploading

Thread began 3/05/2010 1:21 pm by ronald_franklin366888 | Last modified 3/14/2010 10:42 am by ronald_franklin366888 | 1537 views | 12 replies

balexander389215

The products are there and work fine. If I click on show all products they show up almost immediately. It's only if I click on any category that they fail to show up. It gets busy for 5 minutes then finally comes back empty. There is something about uploading the ps3_productcategories that does me in.

To answer the question of the form for uploading the data it's a csv spreadsheet. You do this through phpMyAdmin on the server. You will find your Power Store database there and there are three main tables that need to be filled. The ps3_categories I did not upload but rather did that one manually. The next one is the ps3_products table. Opening this table will show you the fields or columns that need to be populated. Ignore the first one, ProductID. That's a system number. All the others have to be filled out. I tried it with only a few columns intending to later go back and fill in other columns but I could only get it to append the data. So I had to wipe it out and start over. I'm sure there's a way to fill out part of the table and go back later and do the rest but that knowledge is beyond me.

One of the things I learned is to make sure I put a 1 in the ProductLive column. The point of uploading is so you don't have to go to each and every product to set its status.

Using a spreadsheet you head each column with the name of the column heading from the database table. You then fill in the information, save as a csv and in phpmyadmin open the table you want the information in ps3_products and import.

The other table you want to condiser if you number in the thousands of items is the ps3_productcateroties table. This links products to categories os if you don't import this into the database you'll have to visit each product individually to connect to categories and if you're going to do that then you might as well do it all manually.

This is where I had trouble. I can see this table populated and in Power Store admin I, checking products randomly they are in the proper categories. However as I said before my store did not function beyond that point. I may try this again with a smaller table just to see if I can figure out what's going on but I'm no longer worried about it.

Creating the ps3_productcategories csv spread sheet is a lot of fun. It combines the CategoryID from the categories table and the ProductID from the products table. The CategoryID is a sequential number applied to the categories and subcategories in the order they are entered into the table. You then have to take this number and put in in a column beside each product that is in this category. It took me a day and a half, with 5500 items to get it all filled in and correct.

Good luck with it.

Attached Files
Inventory upload.zip

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.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...