Sell With List Price

I want to sell with list price

Example: PRODUCT X = 0 PRICE and 50euro LIST PRICE

and i want to sell in this case

Not how cscart works. Just use price and ignore list price.

i can`t

column “price” is not on the “product” table on cscart mysql, and i have a management software which synchronizes “productcode” and “listprice”



“listprice” is in the “cs_product” with “product code” this tabel synchronizes

[quote name='becomarius' timestamp='1410242577' post='191725']

i can`t

column “price” is not on the “product” table on cscart mysql, and i have a management software which synchronizes “productcode” and “listprice”



“listprice” is in the “cs_product” with “product code” this tabel synchronizes

[/quote]



Hire someone to rework your synchronization script or create an additional one, which will transfer list price to the product_prices table.

i cant<br /> i cant because “product_prices” table does not contain “productcode”

this is my management software that i buy it

i must rework cs-cart script, an addon something



or do I need an addon that creates identical price with List Price,

…i now eComLabs can do that :)

[quote name=‘becomarius’ timestamp=‘1410250834’ post=‘191745’]

i cant<br /> i cant because “product_prices” table does not contain “productcode”

this is my management software that i buy it

i must rework cs-cart script, an addon something



or do I need an addon that creates identical price with List Price,

…i now eComLabs can do that :)

[/quote]



Please check PM

Not too hard to create a function that maps product code to product_id and then updates the price. The issue is with your updating script. it simply needs to do something akin to:


UPDATE cs_cart_product_prices AS pr
INNER JOIN cscart_products as p ON pr.product_id=p.product_id AND p.product_code='[your_product_code]'
SET price=[your_price] WHERE pr.product_id=p.product_id and pr.usergroup_id=0


Note this query has not been tested, it is intended as an example. Values in brackets are to be replaced by your data A more complete and robust solution would be to create a local function that is called and do the appropriate error checking, etc. The above is very basic and doesn't account for new products nor for any tiered pricing.



Or if you just want to update it from your list_price field you can do:


UPDATE cs_cart_product_prices as pr
LEFT JOIN cscart_products as p ON p.product_id=pr.product_id
SET pr.price=p.list_price WHERE pr.usergroup_id=0 AND pr.lower_limit=1