Jump to content

Exporting product list to Excel


Guest Mystics

Recommended Posts

Guest belliez

Hi,

The easiest way is to upload phpMyAdmin to your webhost which will alow you access to your mySql databases on your domain.

Once you have it installed you can navigate to cubecart_inventory and click export. Select CSV from the options and repace the ; in the fields terminated by with a comma ,

Then export to a file.

Simply load into excel and you have your products to edit....

Uploading new products is a total different matter because you need to change a couple of other tables at the same time (cubecart_cat_idx and cubecart_category) which can be a pain and time consuming.

However there is a couple of mods if you search the forums here that will do the import for you.

Hope this helps.

Paul

Link to comment
Share on other sites

**A CubeCart.org Coder** has an excellent mod for exporting orders in all kinds of ways. I highly recommend it:

Edit: Direct links to mods or mod stores are not allowed. Link removed. -- Sir William

My apologies. Can I say, "Go to CubeCart.org and you will find some great mods and a particular one that does an exceptional job with Excel export functions from a coder who shall remain nameless"? :D

Link to comment
Share on other sites

Guest PorkChop

I also give this mod a Big- "Two Thumbs Up!"

The ability to add a product to multiple categories with ease is great.

The thing I like the best is the fact that you have a complete back-up of your categories and

products.

Example:

You have spent hours adding your products and you lose your store because you were tinkering

around with it. "Sound familiar?"

And probably like me you didn't back-up your database.

With this mod, you just upload your category and product file again.

If you have 50 or 5000 products you will save time and like me a whole lot of cursing at

myself.......

There are too many options to list here, so check it out. :D

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...