I run CREloaded.com 1.6a version of OScommerce. I have issues in 4 areas now and will be needing support in the future on a bigger scale. To start I need to get it up and running as a back-end order entry system. I won’t take online orders for another 6 months to a year.
1) The order editor
1.1) on the admin side allows you to create orders. When a product is has attributes that affect the price... The line item totals equal zero on the form, as well as the invoice. The unit cost is fine. The overall order total is fine... And if it is an item that does not have attributes which affect the price the line item totals are fine (ie 3 items at $11 unit price should have line item total of $33 not zero)
2)The invoice/order printout
2.1) The shop cart side PRINTORDER.PHP picks up the payment details from the payment module scripts and puts them on the print out. (ie your order will not ship until we get payment) On the admin side INVOICE.PHP only show the payment type. I want the details on both.
2.2) When you actually print INVOICE.PHP you see Oscom in the top right. You also see the url info at the bottom. I’d like to eliminate all the things that make it seem “online” on or refer to oscommerce invoice.php
2.3) The clickable text and graphic to print or close PRINTORDER.PHP and INVOICE.PHP actually print onto the paper. That is fine for the shop cart side but not for INVOICE.PHP
2.4) I would like to show the order status in the header of PRINTORDER.PHP and INVOICE.PHP or somewhere visible.
2.5) And do something like IF order_status = “Quote” then Title = ‘QUOTE’ else Title = ‘what it usually is’ so I can send out a quote and if they like it… I change the status and it becomes an order. (we’ll have to tweak reports later to filter our “quotes” since they are not sales.)
2.6) Order_Attributes sort order issue. The product options need to lay out in the same order each time for each product on each order. They do not. This needs to be fixed on the PRINTORDER.PHP and INVOICE.PHP, packing slip and ordering screens as well. It may be a DB issue that I can not figure out.
3) The packing list printout.
3.1) I need to not show client info. No address nothing else about the client. The rest of the info can stay
Just the first 5 letters of the Client Company name as a code in large 18pt font at the top with the order number and SATUS.
3.2) I also need to add the order_products_id which I believe is the line item ID in the order detail portion. This is the autnum field in the “order details” table (called something else in Oscommerce).
Method. You download CREloaded 1.6a patch it with the latest order editor (see bug fixes at CREloaded.com) Get these changes running on your machine upload/email me a zip file that contains the changed files with instructions on where I need to put them inside my Oscom directory.)
Open to your ideas too.
5) 5.1 Attributes. Global Attributes.
I have situation of about 100 products with about 1700 option values. So I'll be coming in about 170k in the attributes table. Is there a way to have those attributes apply to all products or do you have any other thoughts for me?