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

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Importing a spreadsheet

Thread began 6/28/2009 9:06 am by larsentim278054 | Last modified 7/08/2009 10:13 am by Ray Borduin | 3536 views | 16 replies |

larsentim278054

Importing a spreadsheet

Hi -

I have a question regarding importing an excel spreadsheet (or would CSV be better?) to the products database. Is there a way?

And I know it will require images (small and large) - so how would I get those added to the products once it's imported? Will I need to upload the images via ftp before hand and then input the full URL to where they are -in the spreadsheet?

If any of this is possible (I'd imagine it has to be to allow for people with huge product lists) - where would I import it - the MySql database? Would I need specific headers or places where the data would need to be?

I'm guessing I could use phpAdmin and export the database once I add one product and then it might give me a reference to know where to put the data? Would that work? Is there an easier way?

Thanks!

Sign in to reply to this post

Ray BorduinWebAssist

phpAdmin should have a way of importing data from a spreadsheet. You could set a default "no image specified" image for everything, then use the update page to associate images from the admin back end.

Sign in to reply to this post

larsentim278054

How do you handle products that are the same product but a diff. color scheme and you want them to choose a color? How would I add those types of products? (products with options) -- and can there be images associated to those other "options" ? Meaning I'd like to show the product image that is of the other color.

Originally Said By: Ray Borduin
  phpAdmin should have a way of importing data from a spreadsheet. You could set a default "no image specified" image for everything, then use the update page to associate images from the admin back end.  
Sign in to reply to this post

Ray BorduinWebAssist

The current version of powerstore does not support options in that way. You would have to insert them as separate products.

Sign in to reply to this post

larsentim278054

Wow... That's going to add a ton more work.

There's no way to implement this type of item?

Originally Said By: Ray Borduin
  The current version of powerstore does not support options in that way. You would have to insert them as separate products.  
Sign in to reply to this post

Ray BorduinWebAssist

On the contrary there are many ways to implement this type of item.

Inserting as individual items is the easiest way. Any other way would be a ton more work and more technical work.

Sign in to reply to this post

larsentim278054

Okay so I add them all as individual items... I assume it's possible to somehow group them though, right? At the very least - do you think it would be easy when showing one of the colors, to have links to the other color options?

Originally Said By: Ray Borduin
  On the contrary there are many ways to implement this type of item.

Inserting as individual items is the easiest way. Any other way would be a ton more work and more technical work.  
Sign in to reply to this post

larsentim278054

Csv

Also - I did find out that PhpAdmin does allow you to export/import via CSV and this is the output in CSV format:

"ProductID";"ProductSKU";"ProductName";"ProductPrice";"ProductWeight";"ProductCartDesc";"ProductShortDesc";"ProductLongDesc";"ProductThumb";"ProductImage";"ProductCategoryID";"ProductUpdateDate";"ProductStock";"ProductLive";"ProductUnlimited"

I understand most of it, but what about "ProductUpdateDate" and the three that are listed after that (stock,live,unlimited).

Do you know what would go there?

Sign in to reply to this post

Ray BorduinWebAssist

ProductUpdate date is to keep track of the last time the product was updated so that stock can be adjusted based on the inventory at that time.

Stock is the number of items in stock at the last update date.

Product live is a true false field that allows you to quickly add or remove a product or stage it on the back end before making it live for users to purchase.

Product unlimited is a true false boolean field that can be used to mark an item exempt from inventory concerns so that it will be available in stock regardless of inventory.

Sign in to reply to this post

larsentim278054

Is it necessary to have data in these fields? Ie - what if I don't know the stock level and the update date - since this is my first time adding these products, should I leave blank? Or put todays date? Product live I would enter "true" then and unlimited would be false? Or if I don't know the inventory level, would I make it unlimited?

Thanks Ray!

Originally Said By: Ray Borduin
  ProductUpdate date is to keep track of the last time the product was updated so that stock can be adjusted based on the inventory at that time.

Stock is the number of items in stock at the last update date.

Product live is a true false field that allows you to quickly add or remove a product or stage it on the back end before making it live for users to purchase.

Product unlimited is a true false boolean field that can be used to mark an item exempt from inventory concerns so that it will be available in stock regardless of inventory.  
Sign in to reply to this post
loading

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...