Problems with Sale maker

Pls see my web site here Click Crystak Figurines -> Animal -> (choose) bear, no need to creat account. Add to cart you will see 10% not addding on. If you go to another part of the category (ie. Decoratives), then the sale maker works adding the 10%.. This is set global in Sale Maker.

Web site: https://www.csgiftstore.com/index.php

Can someone help plssssssssss

How do you have your SaleMake sale setup?

What Categories are included?

Are all Products you "think" are on sale set for that Category or Categories as the master_categories_id

Are these Products Linked Products ... as in do they exist in multiple Categories?

If you switch to Classic, do the prices work correctly?

Dear Linda,
Thks for reply. I been reading up on forum I you EZP and I think the issue might my on the dates. There was a posting on how I should format the date and time, but when I do this the year shos up as 2015. I then went back to old upload and the dates looked fine. I also hv no linked products. The items that are not pulling up the discount, I delete and re enter then it works... It seems it has to do with the EZP. I also went to Store manager and reset the ID, but still no luck.. I should hv just stuck with adding item by item, cause the EZP is giving me a problems and I'm spending to much time on this. I don't know if you can assist any further.

Pls let me know.

Thks

Covone

Under sale maker I set 10% to the Crystal Figurine category. I tried going back to classic but samething happens.. just when I thought i was close to finishing
:o(

Linda,
I ended up deleting the whole category and then uploading the txt file and did a reset in store manager.. that seemed to work but the images are not pulling.. i don't know why? i hv to go to each product and call image again?

I'm having the same issue- is there a way to fix it without deleting the items? The sale worked on the first one I did, but all others since then say they work, but don't actually show up.

Be sure that the products being put on Sale in the Category have that categories_id as their master_categories_id ... otherwise they do not hear the Sale that you set ...

Is there a way to reset the category id without deleting and reloading, or duplicating to the same category? Or do we have to redo everything from the beginning?
We're using an easy-populate program to upload the inventory- so do you know if we have to set something in there to find the master ids of the folders?

Thanks for all the help, especially at the hoildays!

In the Tools ... Store Manager ... is an Update Master Categories ID ...

What that does is pick the first categories_id for a product in the products_to_categories table ...

If you do not use Linked Products then this is always correct ...

If you use Linked Products you will want to check that this is the right one being set ...

After running the Update Master Categories ID you then want to run the Update Products Price Sorter ...

NOTE: backup before running these ...

Hi Linda, resetting categories is a pain. I have a site where I sell jewelry and other gift items. The master categories are often the jewelry type and then I also link them to seasonal types, holiday, theme, etc. So like now I am having (or attempting to have) a Halloween sale. I really do not want to recategorize verything. Why does SaleMaker only work off the master ID and not all of them, seems like it should work on any level not just masters.

You can go in and set Sale Maker to use the Categories or subcategories to make your sales, but the master_categories_id is used as products in 3 categories are the same price ...

Going thru a store and picking up the widget in Aisle A, S or Z should still have the same price on the widget ... so to manage this, while the product can be in multiple places, there has to be a master_categories_id as Sale Maker is designed to put Categories on Sale ...

So ... one ( 1 ) single category must therefor own the product to do this correctly ...

I understand your statement about widgets. But in order to put a category on sale all widgets I wish to have on sale must be under that category and have it as their main category.

The way it should be able to work is that any product listed under a category, regardless of master category, will be put on sale, not just the ones with that category as a master category.

My gothic necklace which has a master of necklaces and is linked to gothic should be able to be put on sale as a gothic product and if seen from the gothic category or necklace category still have the same price. However to put it on sale using gothic I have to remaster it to gothic. What a pain.

What I am asking is why is sale maker 'tied' to the master category rather than searching all items with a category of 'x'?

Alrighty no response in awhile on this thread.

I am currently using a work around by using a coupon system. The bad part about using coupons for a sale is that the discount is not shown until step three of the checkout process.

The interesting part is that the coupon works on an items complete set of category ids. Both master category and any linked categories. This means I do not have to go in and recategorize everything to give it a discount as I currently do with Sale Maker.

As a part time programmer it makes sense to me that the same code used to operate the coupon category verification can also be used in Sale Maker so it is not dependent on the Master Category for an item.

Feedback is of course welcome about this issue.

Ajeh:

If you use Linked Products you will want to check that this is the right one being set ...

Does it mean that this must be change directly from the Database ? Or can we update it by removing the linkage then reset all product category ID then relink the products ?
What would be the easiest solution ?

Thanks in advance

When looking at your Product List in the Admin ... say you wanted all Products in categories_id 14 to use that as the master_categories_id ...

When you hit C for Copy there is a Multiple Categories Link Manager and at the bottom of the page you will see:

Reset ALL Products in the selected Category to use the selected Category as the new Master Categories ID ...
Example: Resetting Category 22 would set ALL Products in Category 22 to use Category 22 as the Master Category ID
Reset the Master Categories ID for All Products in Category:

This lets you change all Products of the current Category so that the master_categories_id matches ...

NOTE: Backup your database before attempting to use features like this ...

Thanks a lot Linda.
I will try it right now and come back with my feedback.

Saraniel

Hi Linda,

Using the feature "Reset All products in the selected Category to use the selected Cartegory as the new Master Category" does not change anything.

I entered "26" as the Master Category for all my products in Category 26.
Unfortunately, when I edit a product with the "attribute controller" from the category 26, another category different from 26 is displayed at the top of the page !

Don't know what to do

Moreover, looking at the "products_to_categories in the SQL DB, category 26 is not in pole position for the specific products.

Please find attached a snapshot from the attribute manager and the link manager. You will see that even if the master category is set correctly in the link manager, this one is not reflected in the attribute manager, therefore the discount column does not show up.

I also checked that the "product_to_Categories" and "master_categories_id" contains the right id

Any idea ?

Thanks in advance.

Forgot the 2nd attachment