rimstaske Posted November 8, 2022 Share Posted November 8, 2022 Hello. I added discount on 2000 products with discount start and end dates. I chose exact date when discount will start and end. But on products discount period is showed as 'unlimited'. I tried to update importing new products information with excel file (products import), but nothing wasn't changed. Can I get solution how i can remove discount from my products? Link to comment Share on other sites More sharing options...
Daresh Posted November 8, 2022 Share Posted November 8, 2022 Specific prices are stored in the database in a quite simple way. So some idea may be to delete them from the table directly. You can truncate the whole _specific_price table or in case there are also prices from catalof price rules, use this query: DELETE FROM `ps_specific_price` WHERE `id_specific_price_rule` = 0 Link to comment Share on other sites More sharing options...
QuickUpdate.net Posted November 9, 2022 Share Posted November 9, 2022 (edited) You can take a look at QuickUpdate Inventory Manager to help you with this issue if you are not comfortable with SQL to do this. Edited November 9, 2022 by QuickUpdate.net (see edit history) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now