gottaloveit

If you mean the files from the osCommerce contributions section, then the files are usually in zip file format. I don't think the rules allow for posting of URL's, so I would search the Internet for a software that can unzip files.

Recompiling PHP with this module can be tough on some OS's, but even on UNIX/LINUX it is not required to recompile. The fix noted in my previous post allows for PayflowPRO without recompiling PHP, thus working on all OS's. However, the credit card error is because the expiration date being sent to PayflowPRO is not the correct format. The contribution V1.2 fixes that and if you follow the contribution install instructions, it should work fine.

Try this update (V1.2 fix) http://www.oscommerce.com/community/contributions,1019

i've integrated payflowpro and oscommerce so you dont have to log into both admin areas. feel free to contact me if you want more info.

see my post: http://www.oscommerce.com/forums/index.php?act=ST&f=21&t=104267

I have payflowpro working. If you are on a shared host, it is going to be a little tough because you either have to have PHP recompiled with payflowpro support or use the fix in the mentioned contrib to run it as binary. But you still need the verisign SDK to get the lib and cert files and put them on your server. Feel free to contact me privately if you need more help.

I would try playing with the stylesheets.

try this: faster loading times

i have used http://www.fpdf.org/ to create packing slips with barcodes on them for warehouse to scan packing slip number. i would rather not post openly as some of the info in the packing slip is proprietary to my customer, however, if anyone is interested, feel free to message me or email me.

Hi there, I have a somewhat interesting situation, I am hoping the coupon gurus can help out with. I am in the process of finishing a store. The store has many products, and the coupons are only on certain products. So while the entire order shows a coupon discount, the coupon discount is still only based on the "eligible" products. The store authorizes the credit card upon checkout, and then ships items accordingly as stock permits. Well, the store only charges the card for the items shipped when they ship the item(s). The charge for each item needs to include the applicaple coupon discount applied, if any. So basically, has anyone come up with something like this, where, not only is the coupon applied to the order, but in the tables, its actually mapped to the products inside the order? At what point during checkout process would you try to do map this in the db, plus a myriad of other questions. Any and all insight, thoughts, suggesstions are most appreciated. thank you, Gottaloveit

Hi there, I have a somewhat interesting situation, I am hoping the coupon gurus can help out with. I am in the process of finishing a store. The store has many products, and the coupons are only on certain products. So while the entire order shows a coupon discount, the coupon discount is still only based on the "eligible" products. The store authorizes the credit card upon checkout, and then ships items accordingly as stock permits. Well, the store only charges the card for the items shipped when they ship the item(s). The charge for each item needs to include the applicaple coupon discount applied, if any. So basically, has anyone come up with something like this, where, not only is the coupon applied to the order, but in the tables, its actually mapped to the products inside the order? At what point during checkout process would you try to do map this in the db, plus a myriad of other questions. Any and all insight, thoughts, suggesstions are most appreciated. thank you, Gottaloveit

How about this: On my backup.php file i inserted this text on line 411 after the <tr> <td class="smallText" colspan="4"><?php echo TEXT_LAST_RESTORATION . ' ' . DB_LAST_RESTORE . ' <a href="' . tep_href_link(FILENAME_BACKUP, 'action=forget') . '">' . TEXT_FORGET . '</a>'; ?></td> </tr> <?php } ?> and before the </table></td> <?php $heading = array(); <?php // beginning of optimizing date add on ?> <tr> <td class="smallText" colspan="4"> <?php $optimize_date_query = tep_db_query("select date_format(start_date,\"%m-%d-%Y) as start_date from optimize_check where counter = '1'"); $optimize_date = tep_db_fetch_array($optimize_date_query); echo 'Database Last Auto-Optimized: <b>'.$optimize_date['start_date'].'</b>'; ?> </td> </tr> <?php // end of optimizing date add on ?> Hope that helps

This is a great contribution. one idea though, possible change. i installed on a heavily modified installation, with lots of traffic. there are 144 tables so far on this site, with feature plans probably growing to about 160. because of this, and because we don't want any customer to lose performance, i decided to put the: require(DIR_FS_CATALOG . 'optimize_table.php'); inside /admin/index.php as: require('optimize_table.php'); and put the optimize_table.php file in the same folder as the /admin/index.php file. this way, the script loads whenever an admin logs in. food for thought, but great contrib. thanks :)

Hello, sounds like you got a great method to get your orders shipped out. By using this method with QuickBooks, is there a method created or thought of that would export the tracking number back into oscommerce and then send a customer email?

The instructions in the mod had the following: In \admin\includes\database_tables.php add: define('TABLE_CANCELLED_ORDERS', 'cancelled_orders'); define('TABLE_CANCELLED_ORDERS_PRODUCTS', 'cancelled_orders_products'); define('TABLE_CANCELLED_ORDERS_PRODUCTS_ATTRIBUTES', 'cancelled_orders_products_attributes'); define('TABLE_CANCELLED_ORDERS_PRODUCTS_DOWNLOAD', 'cancelled_orders_products_download'); define('TABLE_CANCELLED_ORDERS_STATUS_HISTORY', 'cancelled_orders_status_history'); define('TABLE_CANCELLED_ORDERS_TOTAL', 'cancelled_orders_total'); in \admin\includes\filenames.php add: define('FILENAME_CANCELLED_ORDERS', 'cancelled_orders.php'); Were those 2 files modified?

Have you done any other modifications to the orders tables? Check if the tables orders_products and cancelled_orders_products are of the same structure by comparing the two tables.

Hello, I have posted an update to this contrib as Version 1.1. Version 1.1 has these additional features: Added customer view from "my account" page Added database tables to admin/backup script Download from osCommerce at: http://www.oscommerce.com/community/contributions,1744

Hello, I have installed sales report 2. What do you mean by: ? Are you referring to product model number, order number?

I had a lot of these problems too. I'd get error fixed and another would pop up. I finally scrapped it.

Hello all, please use this topic for bug feedback, additions, etc. for this contribution. See: Cancelled Orders Contribution in the osCommerce Contribution Announcement Forum and also Cancelled Orders Contribution download from www.osCommerce.com contributions. Thank you.

Thanks ctechgroup, and yeah, I have already started working on pulling the script into osCommerce and as a contrib. Stay tuned.

Forgive me if this has been talked about, but I could not find a solution, so I figured I would post it. I particularly did not want to worry about sending my data feed to Google / Froogle once a month, as they expire your listings monthly, unless you resend your feed. Also, per their feed requirements, and because my store is relatively small and simple, I needed to modify what Easy Contribute outputted. I decided to set up a CRON job that actually runs every 3 weeks, just to stay a little ahead of Google expiring my listings. The CRON calls a MySQL script that I wrote to export my products. A couple notes so I don't get too flamed B) The product line in our store does not change that often, so I did not incorporate limiting the export to ACTIVE products. If you have inactive products, you might need to change the script. Also, my category levels are only 2 deep, and the 2nd level would not make too much sense to Froogle. Again, if you have a different method for your categories and naming, you might need to change the script. Also, even though I got my feed approved / validated by Google, please make sure to go through the process to get it validated by Google for your store. mysql -uXXXX -pXXXXX -DXXXXX -e "select concat('http://YOUR_DOMAIN_GOES_HERE/product_info.php?products_id=',products.products_id) AS product_url, products_description.products_name AS name, products_description.products_description AS description, FORMAT(products.products_price,2) AS price, CONCAT('http://YOUR_DOMAIN_GOES_HERE/images/',products.products_image) AS image_url, categories_description.categories_name AS category FROM categories, products, products_description, categories_description, products_to_categories WHERE products.products_id=products_description.products_id AND products.products_id=products_to_categories.products_id AND products_to_categories.categories_id=categories.categories_id AND categories_description.categories_id=IF(categories.parent_id='0',categories.categories_id,categories.parent_id)" > /tmp/FILENAME_PER_GOOGLE_SPECS.txt; Once the script is performed, I have CRON FTP the file to Google. Now, I never have to worry about it :D