random183

Thats great thanks. would $month = date("m-1"); work? IE So you had a rolling "Last Month" query. Cheers Mat

Thanks for that, very useful, it's the SQL Queries I always have problems with! This seems to be returning averything for one month behind the date it is, so for example today it would do data from 17th March to 17th April? I was trying to set it so it would do figures for March I'm probably asking too much for it to do this though.. Mat

Anyone have any idea on this? Would be really handy to know! Thanks Mat

Finally found the support thread for this! I'm trying to add a few extra stats onto this, suce as previous months amount in the total sales, that kind of thing. So Essentially I think I need to tweak this code to make a new variable for "last Months Sales" for example. $sales_query_raw = "select ot.value from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_TOTAL . " ot where o.orders_id = ot.orders_id and ot.class = 'ot_subtotal' and o.date_purchased >= '" . date("Y-m") . "-01' and o.date_purchased <= '" . date("Y-m") . "-31' "; $sales_query = tep_db_query($sales_query_raw); while ($sales = tep_db_fetch_array($sales_query)) { $monthlyTotal = $monthlyTotal + $sales['value']; } Or More specifically this bit.. and o.date_purchased >= '" . date("Y-m") . "-01' and o.date_purchased <= '" . date("Y-m") . "-31' I've tried loads of different permutations, and just can't get it to do last month! (Or Last year for that matter!) Does anyone who actually knows how SQL Queries work got any ideas? Cheers Mat

Hi, I've been using this contribution for quite a while now and have to say it's one of the most useful I've added. However, one little question / query / request... Is it possible to have a quantity for certain attributes? For example I want to sell shoes. So I would like to have Style - Black Shoe Size 5 - Quantity 25 Size 6 - Quantity 15 Size 7 - Quantity 5 Ideally this would be handled the same way as the standard quantity calculations in Oscommerce. As I see it at the momnet, I need to creat a different item for each size of each type of shoe, which will be messy if nothing else! I've had a good hunt around and there are a couple of additional contributions, but if it could be integrated into this one, then that would be the best solution, plus I don't know if the other contributions will "play well" with this one. Hopefully somebody else has had a similr requirement and can point me in the right direction... Cheers Mat

How about this? http://addons.oscommerce.com/info/2293 Optional Related Products 1.0 for osCommerce Online Merchant v2.2 Manage relationships between your products to help customers find related products. Quick install, easy to use, helpful to your customers. I've installed it and it works fine !

I don't see that PayPal would have much say in my website? If I wanted to modify the module to take customers to a different part of their website is this such a bad thing? As far as I'm concerned, Ease of use comes first, PayPal maybe getting a new customer is a very minor secondary feature in my mind. At the end of the day I'm their customer they are getting the money off me, surely I should be able to use their site to suit me? Is there any issues with modifying the Payment modules in a legal sense, or in a PayPal will kill your account if you do sense? Yup, Capital letters saying CREDIT CARDS NO PAYPAL ACCOUNT NEEDED, and a help page with huge arrows pointing at the pathetically small link at the bottom of the page.

I'm currently using the PayPal Website Payments Standard Payment module, which seems to be causing all kinds of problems. It's working, but is such a faff for the customers to use. If they just want to pay with a Credit Card they need to find a tiny link at the bottom of the page and click there. We're getting loads of customers who just bail out when they hit the PayPal screen and never pay, leaving Filled carts up in the air without a payment! I'm convinced it's because of this. Is there a Module that just takes you to the second screen? (IE the one that appears once you've found the tiny link?) Ideally as a separate Module where I could then offer PayPal, (Via the existing link), or Credit/Debit Cards using the alternative module with the more user friendly link.. Any thoughts, suggestions anyone? Cheers Mat

Shame! One of my customers who really doesn't want to be going "under the bonnet" of the shop (as they put it), keeps running out of hard drive space on their hosting, and it's always the auto backup thats caused it. Once a shop is running well, you really only need to keep the database for product/customer information, can't really think of anything else that's likely to change much after the shops development phase... It would be really useful to have a "Delete Backups after XX days", any chance you could be persuaded to have a re-think about this? Cheers Mat

Nice one Scott, great stuff, fixed the problem perfectly. Cheers Mat

Hi, Great contribution, I can see this being very useful as the data builds up! One minor issue though, on the report "Last 10 Site visitors" the button "Next Ten Results" at the bottom does'nt work! No errors or anything, just does'nt do anything! I've had a good look through the firum, but can't find anything, and seing as it's on a new page I doubt it's anything to do with my install... (Though happy to be proved wrong!) Any ideas? Cheers Mat

Hi, Great idea with the transparent gifs, I was thinking of a selection of jpgs all put together carefully to create the final item, but I like your idea better! One thought about this is that some of the product images might look a bit odd if there has to be a bit of spacing to allow everything to slot together, what might work is to have 2 pics per item, one for the main pic, and one for the "print preview"pic? I've copied and pasted the currency settings for the store below, so you can see how it's formatted. Title: UK Pound Code: GBP Symbol Left: £ Symbol Right: Decimal Point: . Thousands Point: . Decimal Places: 2 Last Updated: 02/16/2008 Value: 1.00000000 Example Output: £30.00 = £30.00 Taking the decimal point out of the thousands setting has fixed the error, though technically this is a bit of a "fix" rather than repair the issue? Cheers Mat

Hi. Great update, love the new features, I like being able to have the created product hidden from other customers, it was a feature I was going to request! I've installed the upgrade, all went well, nice and easy however unfortunately the prices are still a bit out! I've attached an image below to show what happens, as it's probably much easier As you can see the total is still wrong, but this time it's just a decimal place in the wrong place! This error also happens on the print preview. Once the item is added to the cart the price is correct again! Also, a little request for a little help, as you can see I have pics for each part of the dress, (these are just temporary ones!) How hard would it be to combine all the separate parts into one big picture to give an overall impression of the finished article in the "print preview" page? I'm not asking for you to write this! Just a few pointers!!! Thanks Mat

Hi. I have to admit I'm no expert in this, i just got to know this contribution because it cost me a bit of time to get it working :) You do have a competition setup? Otherwise it could be many different things... 1st stage would be to check each modification you did to make sure they're right. In the past I've found a simple missing character in a language file can cause this error for example. Another thing to check is your database to make sure the additions went in there properly. I wouldn't think it's your server, if it can host osCommerce it can do the extra bit for the competitions.. Mat

It's in catalog\includes\languages\english\competition.php around line 21 Mat

That worked a treat! :) Spot on! Cheers Mat

Cool, Looking forward to it! Cheers Mat

Hi Mike, Have you managed to take a look at the code to determine the cause of this issue? Now it's been determined that if you have an OSCID it works but without it doesn't I was hoping it might have helped solve the issue? Also any luck with the currency/pricing issue too? You said you didn't like the code and were going to rewrite it... Not nagging/pushing etc, just would hate to see a great contribution die due to not being able to get it working.... :) Cheers Mat

OK, This doesn't work... Run the script and just get the error message "Triplify is not activated!" There is nothing in the software to activate/deactivate it. Looking at the code the include is ../admin/includes/configure.php which won't work for most as the admin folder will have some sort of password protection on it. There appears to be a variable called TRIPLIFY_VALUE, where is this set? From what I can see this is half a contribution? Shame really, as were working on Semantics for web scrapers here, and thought I'd see how this compared... Mat

Well spotted! :) I'll second that. Just tested it myself, and it's the same for me! If I have the osCsid then I can preview and go to the cart. Mat

Try This :- Remember to replace the XXXXX with the number you got from the previous query:- Mat

Why not use the manual SQL Scripts I uploaded? I couldn't get the automatic ones to work. Mat

Hi, I've added that code as you asked... When first going into the builder_main.php page initially I get :- POST:Array ( ) 1 GET:Array ( ) 1 When I click the "Add to Cart" button, it just takes me directly to the index (front) page, so no listing for POST & GET. However... When I click "Form Reset" i get POST:Array ( [products_id] => Array ( [0] => -1 [1] => -1 [2] => -1 [3] => -1 [4] => -1 ) [qty] => Array ( [0] => 1 [1] => 1 [2] => 1 [3] => 1 [4] => 1 ) [select1] => [sum] => [totprint] => [totsum] => [price] => [product] => [description] => [image] => [pid] => [p_id] => [recid] => [ammount] => [p_qty] => ) 1 GET:Array ( ) 1 I added your code to index.php and got POST:Array ( ) 1 GET:Array ( ) 1 When I was redirected. I tried creating an item and adding to cart both before and after hitting "Form Reset" to see if this made any difference but it didn't (i.e with both outputs for POST & GET) Hope this helps... Mat

Could my issues be with PHP 5? Just a thought.... Glad to see you've go it running, gives me hope! :) (I really want to get this working!!) Yes... Found that, lets me select items fine, it's just the info button, the page it brings up is empty, not a biggie I reckon I can fix that...

OK, I've now had a really good play with this, and think I've got myself a bit of a bug list. (Please don't take this as a complaint, just constructive discussion! :rolleyes: ) For the record, this is running on RC2a using IE7 (Mostly, though have checked with Firefox, IE6 and Chrome) Some modifications to the store, but mostly just appearance, the general way it works is the same. Some of this will be repetition, but I thought I'd get everything I've found together. Plus some may just be me not expecting it to work as it does... Mods Include.. More Pics 6 Auto Thumbnailer Graphical Borders Header Tags for Novices Flash Rotator Who's Online 3.4 Google Sitemaps Google Analyitics Hide Categories And a couple of others, but like I said, most don't really affect the core way OS Commerce Works. Plus changed Stylesheet for making the colours right for the shop. So Bugs.. 1. Prices Incorrect. - Have tried changing every setting in the shop for the currency settings, but I find that anything that is prices as £5.00 is displayed as £500. All other parts of the shop work correctly, the correct amount is sent to PayPal for example, so I'm guessing the shop is setup correctly. 2. Can't add the created item to the cart. I select something for each of the selections, and click "add To Cart" and I get taken straight to the Index page in the catalog folder. I check the Category and nothings in there, and nothings in the cart. I've tried this as a guest, and as a Registered Customer, neither way works. I get the same result if I disable "Preview build before going to Cart". I've checked the items in the database and nothing's there either. 3. The preview button in not working properly? I get a basic screen, just black and white, no images etc, is this correct. Not a massive issue as I can probably tweak this to my own look anyway. 4. Are the yellow triangles supposed to be there when there is no selection made? I've tried adding an image in "Image Filename" when setting up the categories but this doesn't change. Also tried the option "Display category Images instead of Text Labels" with no success. Should they be changeable, or is this a misunderstanding on my part? 5. The pop-up box where you select the component does not show any images, just the Title / Description. Is this correct? I've looked for an option to turn them on, but I can't see one. Again, probably me missing something... 6. Because I'm using products that are disabled, the Info Button is not working properly. It shows the product_info page with 0 value and no description/title. Again not a biggie, will probably create a custom page for this based on the original that will show the details of any product, disabled or not. I Guess that's enough to be going on with! :thumbsup: If I could just get the product into the shopping cart, then I think I could probably fix everything else myself... Cheers Mat