Jump to content


  • Content count

  • Joined

  • Last visited

Profile Information

  • Real Name
    Junior ATV Sales
  1. junioratv.com

    looking for backend add-ons

    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!
  2. junioratv.com

    Star Product Error - HELP - NOOBIE HERE

    nobody out there?
  3. junioratv.com

    Star Product Error - HELP - NOOBIE HERE

    can anybody help here? I'm pretty screwd!
  4. 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
  5. junioratv.com

    Paypal IPN troubles

    fixed it. Sorry, I couldnt delete it.
  6. junioratv.com

    Paypal IPN troubles

    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', 'john@johncastaldi.com', '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')