How to remove sale price?

N

nathaniel7sg

New Member
I try removing sale price through csv, later the plugin automatically updates the sale price. I don't want the products to be on sale. Help me with this. I can't re-import everything, I store files in Amazon S3 and re-importing costs me. Tell me how to stop the sale.
 
N

nathaniel7sg

New Member
From the link you sent, I got the idea to edit the wp_adsw_ali_meta table using sql , setting the sale price to 0.

UPDATE `wp_adsw_ali_meta` SET `origSalePrice`=0,`origSalePriceMax`=0;

I hope that query would fix it! Thanks!!
 
Direct Webstore

Direct Webstore

Well-Known Member
nathaniel7sg said:
From the link you sent, I got the idea to edit the wp_adsw_ali_meta table using sql , setting the sale price to 0.
Click to expand...
Good idea. Not sure if that will be overwritten when the AliWoo plugin updates itself though. Probably not.
Better check after the next update.

Let us know what happens. I'm happy with Sale prices at the moment, but maybe in the future, I'll change my mind.

:)
 
N

nathaniel7sg

New Member
I think it is here in skuOriginalAttr

example:

a:14:{s:27:"200000531:193;249:200006305";a:3:{s:5:"price";s:5:"77.22";s:9:"salePrice";s:5:"54.05";s:8:"quantity";i:3396;}s:27:"200000531:193;249:200006306";a:3:{s:5:"price";s:5:"77.22";s:9:"salePrice";s:5:"54.05";s:8:"quantity";i:3399;}s:30:"200000531:365458;249:200006305";a:3:{s:5:"price";s:6:"124.74";s:9:"salePrice";s:5:"87.32";s:8:"quantity";i:3399;}s:30:"200000531:365458;249:200006306";a:3:{s:5:"price";s:6:"124.74";s:9:"salePrice";s:5:"87.32";s:8:"quantity";i:3397;}s:27:"200000531:173;249:200006305";a:3:{s:5:"price";s:5:"95.04";s:9:"salePrice";s:5:"66.53";s:8:"quantity";i:3396;}s:27:"200000531:173;249:200006306";a:3:{s:5:"price";s:5:"95.04";s:9:"salePrice";s:5:"66.53";s:8:"quantity";i:3399;}s:30:"200000531:350852;249:200006305";a:3:{s:5:"price";s:6:"136.62";s:9:"salePrice";s:5:"95.63";s:8:"quantity";i:3399;}s:30:"200000531:350852;249:200006306";a:3:{s:5:"price";s:6:"136.62";s:9:"salePrice";s:5:"95.63";s:8:"quantity";i:3399;}s:27:"200000531:175;249:200006305";a:3:{s:5:"price";s:6:"126.72";s:9:"salePrice";s:5:"88.70";s:8:"quantity";i:3399;}s:27:"200000531:175;249:200006306";a:3:{s:5:"price";s:6:"126.72";s:9:"salePrice";s:5:"88.70";s:8:"quantity";i:3399;}s:27:"200000531:496;249:200006305";a:3:{s:5:"price";s:6:"136.62";s:9:"salePrice";s:5:"95.63";s:8:"quantity";i:3399;}s:27:"200000531:496;249:200006306";a:3:{s:5:"price";s:6:"136.62";s:9:"salePrice";s:5:"95.63";s:8:"quantity";i:3396;}s:28:"200000531:1052;249:200006305";a:3:{s:5:"price";s:6:"124.74";s:9:"salePrice";s:5:"87.32";s:8:"quantity";i:3398;}s:28:"200000531:1052;249:200006306";a:3:{s:5:"price";s:6:"124.74";s:9:"salePrice";s:5:"87.32";s:8:"quantity";i:3399;}}

The real product has 7x2 variations. I guess this is it..........This is hectic o_O Maybe the only possible way is to make a programme.

Can Anyone from the admin confirm if this is the real thing, I don't want to risk !
 
You must log in or register to reply here.
Top