invpts3 Posted October 11, 2014 Share Posted October 11, 2014 Hi there, some problems here with using CSV discount fields. Two examples. Example 1 When I want a product to be on sale I fill out the following fields in my CSV. On Sale: 1 Discount amount: 10 The discount is showing up at the product. A week later the Sale is over and I change my CSV-file as follows: On Sale: 0 Discount amount: 0 I upload the Product-CSV with "Use product reference as key" set to YES. What happens is the Sale still being active at the productpage. I can only get rid of the Sale showing up when turning "Delete all products before import" to YES. But then I lose all my images. Example 2 When I want a product to be on sale for a specific period, I fill out the following fields in my CSV. On Sale: 1 Discount percentage: 5 Discount from: 2014-9-5Discount to: 2014-9-10 What happens is that the discount is showing up at the product. But when the date is elapsed, the discount is still online. Also in the Specific Prices of the product within the admin, the period is set to unlimited. This doesn't seem to work. Is there a solution for this? Let me know! Link to comment Share on other sites More sharing options...
prestamax Posted October 11, 2014 Share Posted October 11, 2014 Not sure if it makes a difference but I think the date should have two numbers at month and date (a leading zero if its a single number) Discount from (yyyy-mm-dd) Discount to (yyyy-mm-dd) Discount percentage: 5 Discount from: 2014-09-05Discount to: 2014-09-10 Link to comment Share on other sites More sharing options...
invpts3 Posted October 11, 2014 Author Share Posted October 11, 2014 I tested it, it makes no difference. Link to comment Share on other sites More sharing options...
prestamax Posted October 11, 2014 Share Posted October 11, 2014 (edited) hmm .. maybe you should report it to the bug tracker. If I upload an updated csv file I check "Force ID numbers" and I have never lost any image even if I delete all products before import. Edited October 11, 2014 by prestamax (see edit history) Link to comment Share on other sites More sharing options...
invpts3 Posted October 12, 2014 Author Share Posted October 12, 2014 (edited) Just a little test for the images. Force ID, and at the same time All Products Delete doesn't work for me. I tested it with a custom theme and with bootstrap on different domains. Before I started testing. In every shop I first imported the products and for the first product I added an image via prestashop. And after every import I when an image was deleted, I added it again before doing a next import test. Tested all possible settings just to be sure. No difference as you can see in the attachment. So Deleting Products could be a solution to delete a Discount if the images should remain intact. But in my prestashops they don't. Edited October 12, 2014 by invpts3 (see edit history) Link to comment Share on other sites More sharing options...
prestamax Posted October 13, 2014 Share Posted October 13, 2014 I am uploading the images via csv this makes it much easier. Just create a folder let's say "photos" in your root directory, upload your photos via ftp and import them in your csv file ./../photos/imagename.jpgSo you have all control over your images via csv. 1 Link to comment Share on other sites More sharing options...
invpts3 Posted October 13, 2014 Author Share Posted October 13, 2014 (edited) As you can see in the attached file, the only way to delete a Discount is to delete all of the products. Followed by an automatic deleting of all the images. A little weird is that the SALE-icon is deleted in Tests 6,7 and 9 but the discount still remains. So images trough FTP and putting them in the CSV as you mention, is the only available option to turn off discount via CSV and at the same time not getting into trouble with the images. Otherwise you have to delete the discount by hand via Presta backoffice. Does Prestashop have any options or modules to make this FTP-upload combined with a product-CSV easy for people who are not the best with PC's and internet? Edited October 13, 2014 by invpts3 (see edit history) Link to comment Share on other sites More sharing options...
Bellcross Posted March 17, 2016 Share Posted March 17, 2016 2 years later and this still seems to be a problem. Changing "On Sale" to "0" from "1" via CSV import does not remove specials on products. I have to either manually remove the specials from the backend or delete all products before import. Link to comment Share on other sites More sharing options...
mitzone19 Posted September 23, 2017 Share Posted September 23, 2017 Find this row In AdminImportController.php: if ((isset($info['reduction_price']) && $info['reduction_price'] > 0) || (isset($info['reduction_percent']) && $info['reduction_percent'] > 0)) and modify "0" with "-1", don't try to modify ">" with "=" because it will not work. Best regards. 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