junioratv.com

Hi, I am looking for 2 add-ons. #1. I am looking for a way I can take an order, but fill in an item and a price that is NOT in my catelog. the scenario is that I have thousands of parts, but only a few hundred 'hot' ones in my catelog. When someone calls, I want to be able to take their order, take their payment info, and then track the order in my os commerce backend. #2 From my backend, I would like to have a button (just like the print invoice and Packing slip buttons) that would launch a USPS shipping tool, and send the address information so I can print the shipping label instead of re-entering all the address info. I'd love to hear from the pros here!

nobody out there?

can anybody help here? I'm pretty screwd!

select substring(pd.products_description, 1, 598) as products_description, p.products_id, p.products_image, p.manufacturers_id, p.products_price, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price, p.products_tax_class_id, sp.product_id from products p, products_description pd, star_product sp left join specials s on p.products_id = s.products_id where p.products_id = pd.products_id and p.products_status = '1' and pd.products_description != '' and p.products_id=sp.product_id and pd.language_id = '1' [TEP STOP] if I put the red button on, all is okay, but when I activate the star product it bombs here. www.junioratv.com

fixed it. Sorry, I couldnt delete it.

Trying to use the Paypal IPN module instead of the regular paypal module, and I get this on checkout = TOTAL NOOB HERE!! 1406 - Data too long for column 'payment_method' at row 1 insert into orders (customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, date_purchased, orders_status, currency, currency_value) values ('1', 'Lamar Washington', '', '21334143142', '', 'sdffsafsadf', '3423432234', 'Florida', 'United States', '43423234234', '[email protected]', '2', 'Lamar Washington', '', '21334143142', '', 'sdffsafsadf', '3423432234', 'Florida', 'United States', '2', 'Lamar Washington', '', '21334143142', '', 'sdffsafsadf', '3423432234', 'Florida', 'United States', '2', 'PayPal (including Credit Cards and Debit Cards)', '', '', '', '', now(), '4', 'USD', '1.00000000')