in the inventory wizard there is a price change wizard. Is there a way to modify the wizard to put an item on sale using precentage off of MSRP not cost. One of my customers is in an idustry that relies heavily on LIST or MSRP and the vendors actually run sales a few times throughout the year taking money off list not from cost. Is there a way to do it or will an export to excel and the reimport be necesary?
In this case the only constant amount is the LIST or MSRP becase there are volume discounts from the vendor depending on the order size, so they keep the cost at an average percentage off of cost. For example list is $29.99 Monday they oder 20 pieces in the order they get it at 35% off list, Tuesday they place an order for the same book, but this time there are 2000 items on the order so they get 50% off list for the whole order but they do not change the cost of the book (there accounting not mine), but Wednesday- Sunday the same book is put on sale via the vendor 20% off list. The only difference is, that this is not just one book, it 2500 from this vendor and this what happens with all of them. SO generally they use an equation that looks like this with their inventory (LIST - 35%)+35% for normal day pricing during these sale time the equation is (LIST-20%) accross the board for this vendors items.
So the a, b or c pric> HI,
No, the price generally 10-15 points below list, so the assumtion would be off.
Though I appreciate the time and the answer.
"c> Hi Aaron - if I understand you correctly, your regular price is the list
Aaron, if you have to update the sale price of 2500 SKUs and you don't get another posting to your question suggesting using an add-on, you may have to use a SQL query; run the following SELECT statements to view items that would be affected and BACKUP BEFORE RUNNING THE UPDATE QUERIES. Also consider doing this after hours and/or creating your store database from a backup in a separate machine for testing purposes.
For example purposes we'll assume one of your books has an item lookup code of 12345678. Also that you want to update all the items from this supplier "x" items in department "y".
SELECT * from item where itemlookupcode = '12345678';
This will show you item properties for this ILC. Jot down the DepartmentID and the SupplierID. Let's assume the DepartmentID is "9" and SupplierID is "5".
Then run this query to view which items get pulled into your query. SELECT * from item where departmentid = 3 and supplierid = 8;
To view what department and supplier the IDs correspond to run SELECT * from department where id = 3
SELECT * from supplier where id = 8 Your items should have a supplier assigned in the supplier tab of the item properties.
If you see that you're pulling up all of your SKUs that you want to put on sale at say 20% off MSRP between 7/1/07 and 7/3/07, then you're ready for the update query; BACKUP FIRST
UPDATE ITEM SET SALEPRICE = (MSRP*.8), SALETYPE = 1, SALESTARTDATE = '7/1/2007', SALEENDDATE = '7/3/2007' WHERE DEPARTMENTID = 9 AND SUPPLIERID = 5;
This should kick in the "this item is on sale" flag (the "1" in SALETYPE) and enter the begin and end dates of your saleprice.
To remove the sale flag, run UPDATE ITEM SET SALETYPE = 0 WHERE DEPARTMENTID = 9 AND SUPPLIERID = 5;
If after running the SELECT query you see you're pulling in items that you DON"T want to put on sale, you need to find an additional constraint to apply to your WHERE clause. I don't believe there are additional tables to update as it seems that the only table affected by whether an item is on sale is the item table. Wait a few days to see if a more experienced SQL/RMS user can add to this post or if a reseller has an add-on / plugin that will give you a GUI to assign sale price off of MSRP, so you don't have to go into SQL query land.....
Hope this helps.....
"aar> No, the price generally 10-15 points below list, so the assumtion would be > off. >
Aaron, sorry, I messed up in the SELECT * from department where id = 3 and
The "examples" where supposed to be departmentid = 9 and supplierid = 5 H> Aaron, if you have to update the sale price of 2500 SKUs and you don't get
Hi Aaron, did you ever come up with a solution on this. I continue to look for a clean way to do this.
Thanks, Richard
"aar> in the inventory wizard there is a price change wizard. Is there a way to
If you are unable to do this with the wizard, this would actually be something fairly simple to do with an SQL script. Or even have somebody create you a simple add-on that will do this.
Hi Andy, I'm aware of using SQL to do this but I'm reluctant to put this hammer in the hands of my retail staff. I have been looking for a modification to the existing RMS wizard. The guys from RITE said they they could do it for x but when we got a serious quote from them it was looking more like 2x . MS RMS development responded to a query to this modification that it was complicated anmd they referred me back to my partner. So at this point I have not found a simple add-on to accomplish this but I continue to look for a solution.
Richard
"Andy Miller - Boise, Idaho" wrote:
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.