On Sale whether "Sale On" is checked or not

[dnila]

I update my products by editing and uploading the database. I have sale prices for many of my products, but have the "sale on" field checked only for those I want sale prices displayed for. It seems that SS Manager 8.1 does not care if "sale on" is checked or not. All products with a sale price are getting the sale price. What am I doing wrong?

Documentation says:
Sale Amount - A reduced price for the product, or a percentage by which to reduce the Price.

Field Type: Numeric or percentage
Default Value: Null; there is no default value
Possible Values: Any numeric value, but no currency symbol. You can include numeric and decimal separators. To use a percentage off the Price, enter a number and a percent sign, such as 10%.
Comment: The Sale Amount value is only used if the Sale On field is set to "checked."

Sale On - Indicates whether to display the product sale price.

Field Type: Checkbox
Default Value: "checked"
Possible Values: "checked" or null. Setting a null value indicates that this product is not on sale.
Comment: Note that this field has no effect if a Sale Price has not been set for the product.

Dnila

[Jim]

What product template are you using? Is it one you created or a ShopSite supplied version? You have to include a check of the Sale on value to determine whether to display the on sale price.

[dnila]

It's the Compact Graphic over text product template. (ShopSite supplied) I looked in the file and I see it is a C coded template. I would think this check would be built into the code.

Dnila

[loren_d_c]

Are you setting this via an upload? If so, perhaps the null (empty) value in your upload file for these products isn't setting the field correctly. Try manually setting the checkbox to the unchecked state (Products -> Edit Product Layout, make sure the 'On Sale toggle' is unchecked, then Save Changes), Publishing, then checking the page again to see if the sale price is still displayed.

-Loren

[Jim]

It should work in that template. Did you upload the data to you store or did you edit the On Sale Toggle: setting under Edit Product Layout. Check in the backoffice to make sure that that option is specifically unchecked for items you don't want on sale.

[dnila]

It should work in that template. Did you upload the data to you store or did you edit the On Sale Toggle: setting under Edit Product Layout. Check in the backoffice to make sure that that option is specifically unchecked for items you don't want on sale.

Is the On Sale toggle something that is specific to the Pro version? I'm using manager and I don't see an on sale checkbox, just a field for a sale price.

Dnila

[Jim]

The "On Sale Toggle:" is in a manager level store too (I checked an 8.1 version store) This is on the Edit Product LAYOUT screen so make sure that you are on that screen and not the Edit Product Info one.

The check box has the text: "Check here to display this product's on sale price " after it and it is 4th checkbox down on the page.

[dnila]

Ah, there it is. My intiuition was wrong as far as the location of the toggle is concerned, but boy is it ever a nightmare changing all that stuff through the Wizard.

I went back and checked my upload file, and there absolutely is nothing in the fields that shouldn't have the sale on checked. They are null values, back to back tabs with nothing in between.

I think the easier approach to this, if the uploaded data will not work, will be to simply edit the sale price fields. I think it will be easier than monkeying with the wizard.

Thanks to all for the help.

Dnila

[dnila]

I did some experimenting. I fixed the the on sale issues through the wizard. Everything looked fine. I downloaded the database, deleted the existing data, and turned around and uploaded it again. (After I removed that nuisance # sign and the extra carriage return that the download puts in. After uploading, all the sale info is back to the way it was before I fixed it through the wizard, and the check marks that I removed are back. So, I can assume that the check mark is there by default, it cannot be controlled with the "Sale On" field, and the "Sale On" field is non functional.

What a pain if you run a lot of sales as part of your marketing strategy.

Dnila

[knucklehead]

I am having the same problem; but I am not understanding your solution.

The ONSALE field in the products file I am uploading is null, but the field remains checked in SHOPSITE after the upload, after a publish, and after a regeneration.

I do not want to have to run a wizard to adjust products, I have to be able to trust the FILE UPLOAD.

So can you tell me how you were aboe to get that ONSALE box checked via UPLOAD? The only # I see in the NAME Field as part of the fields name NAME#. ????

THANKS!

[dnila]

The only solution I found was to delete the sale price in those products I wanted to take off sale, and put a sale price back in when I wanted the item back on sale. I do this in MS Access by creating a table with a sale price for each sku, and moving the sale price into the sale price field by clicking a button on a form that displays each item. The "sale on" field just stays checked, if there is no sale price it does not show one.

[knucklehead]

So you just setr the value of the Sale Price to= ""

[dnila]

Yes, the sale price field should be left null.

It looks to me like the "sale on" field was a good idea that never got fully implemented.

Dnila