Kryptronic Software Support Forum

You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.

#1 12-06-2020 15:10:53

CrownRoyal
Member
Registered: 01-10-2009
Posts: 716

where is pricing data kept?

Dashboard / Store / Catalog / Product Offers / Configure - All Types / Inventory Item(s)* /

Inv Item ID*
Reg Each / Vol Sch*


Looking to do a bulk edit of some prices based on ID.

UPDATE 'table' SET 'Reg Each / Vol Sch' = '29.95' WHERE id LIKE “%COLOR%”

What is the 'table' and the 'Reg Each / Vol Sch' ?

Last edited by CrownRoyal (12-06-2020 15:11:28)

Offline

 

#2 12-07-2020 11:31:19

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: where is pricing data kept?

Easy Method:  Use the Bulk Price Updater extension module.

Via SQL or CSV Download/Upload:  Access System / Database / Raw Database Admin, and take a look at the ecom_pricemap table.


Nick Hendler

Offline

 

Board footer