Jump to content

Recommended Posts

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-5
Discount 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

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-05
Discount to: 2014-09-10

Link to comment
Share on other sites

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.

post-850717-0-51637100-1413111774_thumb.jpg

Edited by invpts3 (see edit history)
Link to comment
Share on other sites

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.jpg
So you have all control over your images via csv.

  • Like 1
Link to comment
Share on other sites

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?

post-850717-0-89192900-1413195647_thumb.jpg

Edited by invpts3 (see edit history)
Link to comment
Share on other sites

  • 1 year later...

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

  • 1 year later...

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...