NodsDorf

Thank you @raiwa I didn't see that announcement, will take a look. My best!

We are building a new site right now with Phoenix and we'll need to use this add-on. Although it may not be ready I"m wondering if the database structure will remain the same as previous versions of OSC? Or is it too soon to tell? I can do a lot of database work in the meantime if so. Thank you @raiwa and all!

According to the API documentation Authorize.net will only process request with 30 or less individual line items. REF: https://developer.authorize.net/api/reference/ " • lineItems Contains one or more elements (the maximum is 30 line items " This is not an every shop problem, but for some it maybe more prominent than others. In the last 10+ years of using OSC I have ran into this issue exactly 3 times. It wasn't until this last time I actually found this information and realized what the problem was. The solution that I have used in all 3 cases thus far has been to enable COD payment module to generate a customer order. Then use the Authorize.net manual interface to charge the customer's card. From a professional standpoint this has been a bit lackluster and if I was a customer I would have some apprehensions from a random store owner telling me this is how they have to process my order. Thinking about this and the various industries I would imagine this issue comes up more often for others than myself. My in shop solution thought is currently running along the lines of a BYO (Build Your Own) module much like is used with computer purchases. You start with X Computer then add the options / software / hardware you want. In the end you have only 1 product being purchased but it has a multitude of options with it. Exactly how to port this idea over to a common use-able addon is unclear to me. Scenarios in industries with multiple similar low cost items like stickers, or screws, or greeting cards, or general office supplies may face this problem regularly and I am not sure how you port a BYO system over to such an industry. What have you done in the past to overcome this issue?

@@pvoce I see, looks like you went for the last version that had all the frills, I actually installed the version before that. Aside from not getting flat rate values returned from USPS it is working well. USPS Rate V4 Intl Rate V2 - v.1.7 - FIX 11 Feb 2012 Maybe somebody else can lend a hand, or if you don't actually need the product restrict functionality you could use the version above.

@@pvoce Did you uninstall the stock oscommerce usps module before installing this one? Also which method did you use, drop on top, or self modify files? Your problem sounds like some data in this database wasn't cleared or ther is a missing character in the code. I don't know if there are any people who had this problem 14 pages is hard to read through, but I can say I did not have that issue. I can try and help if you want to answer those questions or show a screen shot of what the problem looks like.

@@aerosmith Hi, did you sign up for an account at USPS.com? I noticed when I installed it I did not get any rates until I called them and told me to put me on the production server. According to the emails they sent me they start everybody out on the test server.

@@ehong33234 The following statement in the SQL is incorrect products_length, products_width, products_height, products_ready_to_ship, The error is showing you that it can't find products_length, because the statement is not referencing a table to look at. Notice, all the other request have a p. or pd. in front of them? If you been running your store for 7 years without updating then this isn't the correct module to use as its for 2.3.+ . The statement you referenced likely was part of another addon you installed and not this particular one. Additionally it could be that your previous version of mysql allowed for minor errors in statements which prevented that statement from failing, but recently an upgrade was performed and now the statement needs corrected. If I have to guess I would say this code products_length, products_width, products_height, products_ready_to_ship needs to be p.products_length, p.products_width, p.products_height, p.products_ready_to_ship which would easily be verifiable by looking at your products table in your database to see if those fields are there. Hope that helps

Anybody familiar with why this module wouldn't return Flat Rates even if they are selected? I'm getting rates they are just the exact same as that of the priority mail by weight shipment. Example Priority Mail: $6.35 Flat Rate Box: $6.35 --> where it should be $5.15 Emailed the author but no response in a month. Any insights would be appreciated.

As of 11:45am EST 09/16/2012 I am seeing rates returned.

Hi Jack Step 6 in the catalog install instructions: ====================================================================================================== 6) In includes/database_tables.php, anywhere before the last ?> ADD: /*** Begin Header Tags SEO ***/ define('TABLE_HEADERTAGS', 'headertags'); define('TABLE_HEADERTAGS_CACHE', 'headertags_cache'); define('TABLE_HEADERTAGS_DEFAULT', 'headertags_default'); define('TABLE_HEADERTAGS_SEARCH', 'headertags_search'); define('TABLE_HEADERTAGS_SILO', 'headertags_silo'); /*** End Header Tags SEO ***/ ====================================================================================================== Think it needs added to that: define('TABLE_HEADERTAGS_KEYWORDS', 'headertags_keywords'); At least mine did. Thanks, Don

Didn't realize you both had different versions of the original from Chemo. Either way, I rolled back his, installed yours and everything is perfect. Thanks, yet again. Don

Hi Jack Is there a way for the sitemap to be generated using FWRMedia Ultimate SEO URL's instead of the strict Oscommerce path? Google may find it odd to keep submitting URL's that all get 301 redirected. Thanks, Don

Yep you are correct, The sql query wasn't formatted correctly Took a lot of trys but this finally worked Changed the $sql query to $sql = " SELECT concat( '" . $productURL . "' ,products.products_id) AS product_url, products_model AS prodModel, manufacturers.manufacturers_id, products.products_id AS id, products.minorder AS minorder, products_description.products_name AS name, products_description.products_description AS description, products.products_quantity AS quantity, products.products_status AS prodStatus, products.products_weight AS prodWeight, " . $extraFields . " FORMAT( IFNULL(specials.specials_new_products_price, products.products_price) * products.minorder * " . OPTIONS_TAX_CALC . ",2) AS price, CONCAT( '" . $imageURL . "' ,products.products_image) AS image_url, products_to_categories.categories_id AS prodCatID, categories.parent_id AS catParentID, categories_description.categories_name AS catName FROM (categories, categories_description, products, products_description, products_to_categories) left join manufacturers on ( manufacturers.manufacturers_id = products.manufacturers_id ) left join specials on ( specials.products_id = products.products_id AND ( ( (specials.expires_date > CURRENT_DATE) OR (specials.expires_date is NULL) OR (specials.expires_date = 0) ) AND ( specials.status = 1 ) ) ) 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.categories_id=categories_description.categories_id " . $quotes . " AND categories_description.language_id = " . DEFAULT_LANGUAGE_ID . " AND products_description.language_id = " . DEFAULT_LANGUAGE_ID . " ORDER BY products.products_id ASC "; Added an if statement above the output for the name if ( $row->minorder > 1) { $minorder="(Pack of " . $row->minorder . ")"; } else { $minorder=""; } Then added in the variable into the statement preg_replace($_strip_search, $_strip_replace, strip_tags( strtr($row->name, $_cleaner_array) ) ) . $minorder . "\t" . Many thanks for your time and guidance, and knowledge!

I tried Jack, Just can't figure this one out. I just need to add text to the name title that says Pack of $minorder But I don't understand your coding enough to make it work. I tried adding below this $result=mysql_query( $sql )or die( $FunctionName . ": SQL error " . mysql_error() . "| sql = " . htmlentities($sql) ); while $result=mysql_fetch_array($sql) { $minorder =$row[minorder] } Then changing preg_replace($_strip_search, $_strip_replace, strip_tags( strtr($row->name, $_cleaner_array) ) ) . "\t" . to preg_replace($_strip_search, $_strip_replace, strip_tags( strtr($row->name, $_cleaner_array) ) ) . "(Pack of " . $minorder . ")". "\t" . That just causes a infinite loop. I tried a few others things but I just can't seem to get that $minorder appended to anything. I'm able to use the products.minorder column in the $sql query but not able to use its value anywhere else. Any help is appreciated, Don

That is exactly what I meant, thanks Jack. I'll take a crack a modifing that to include the min-order number. Thanks, Don