Trudy Posted April 27, 2017 Share Posted April 27, 2017 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. Quote Link to comment Share on other sites More sharing options...
bsmither Posted April 27, 2017 Share Posted April 27, 2017 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.) Quote Link to comment Share on other sites More sharing options...
Dirty Butter Posted April 27, 2017 Share Posted April 27, 2017 I would suggest you message @Noodleman , if you don't mind paying for his time. He is a developer. This sounds like something he may have already done for someone else. Quote Link to comment Share on other sites More sharing options...
Trudy Posted April 28, 2017 Author Share Posted April 28, 2017 Thank you for your help. Quote Link to comment Share on other sites More sharing options...
havenswift-hosting Posted April 28, 2017 Share Posted April 28, 2017 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 Quote Link to comment Share on other sites More sharing options...
Trudy Posted April 28, 2017 Author Share Posted April 28, 2017 Thank you, I will give this a try. Quote Link to comment Share on other sites More sharing options...
Sensational Posted January 12, 2018 Share Posted January 12, 2018 i am doing this same thing any help would be great... Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.