Jump to content

Import Catalogue


Trudy

Recommended Posts

Hi, I have setup my products with a retail and wholesale price, is there a way to import both prices? On my first import it put the wholesale price in as the sale price.

Would just save a lot of time if I didn't have to go back through and update the wholesale price manually.

Link to comment
Share on other sites

The Catalogue Import function mostly loads up the CubeCart_inventory database table.

The inventory can hold values for the Retail, Sales, and Cost prices.

A wholesale price, or any other price structure, is held in a separate database table and is associated to a Customer Membership designation. Customers can also be assigned to a Membership designation. Thus, for a "Wholesale" designation, a wholesale customer will see wholesale prices.

Again, all this happens in a separate database tables that the Catalogue Import feature does not disturb.

Through the use of 'hooks' in CubeCart's code, one can possibly augment the Importer to deal with this. (I am unable to assist with this at the present time.)

Link to comment
Share on other sites

15 hours ago, Trudy said:

I have setup my products with a retail and wholesale price, is there a way to import both prices? On my first import it put the wholesale price in as the sale price.

This is something can can be simply done from a csv file using phpMyAdmin.  Import the product code and two prices into a temporary table and then update the Inventory table from that

Link to comment
Share on other sites

  • 8 months later...

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