Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

mwp38

Archived
  • Posts

    16
  • Joined

  • Last visited

Profile Information

  • Real Name
    M P

mwp38's Achievements

  1. ok heres my problem, i have done everything the instructions say to do and when i try to run the first SQL update ( ALTER TABLE `configuration` CHANGE `set_function` `set_function` VARCHAR( 555 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL; ) it gives me this error: SQL-query : ALTER TABLE `configuration` CHANGE `set_function` `set_function` VARCHAR( 555 ) CHARACTER SETlatin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL MySQL said: Too big column length for column 'set_function' (max = 255). Use BLOB instead so i chanfged the VARCHAR( 555 ) to VARCHAR( 255 ) and this is the error i get: SQL-query : ALTER TABLE `configuration` CHANGE `set_function` `set_function` VARCHAR( 255 ) CHARACTER SETlatin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL MySQL said: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'COLLATE latin1_swedish_ci NULL DEFAULT NULL' at line 1 even went as far as changing the VARCHAR( 555 ) to TEXT( 555 ) and still get the following error: SQL-query : ALTER TABLE `configuration` CHANGE `set_function` `set_function` TEXT( 555 ) CHARACTER SETlatin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL MySQL said: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '( 555 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEF HELP!!! any help would be GREATLY appreciated.
  2. Thanks for the response, will give it a try.
  3. Hi everyone, I have a client who ships "LIVE" Bees and they want UPS Next Day Air to be the ONLY shipping method available for this product, all the other products in the catalog need to have all the UPS methods available. Any way to accomplish this? Any help would be greatly appreciated!
  4. I have been having the same problem and I posted a "ticket" to them, here is what i wrote to them: My Question ================================================= I am setting up a shopping cart (OsCommerce) for this Vendor and he has gotten 2 orders in the past 2 days but there is no product information passed to the cart or 2checkout, only a cart number, so he does not know what these people have ordered and has to e-mail them to find out. I have searched endlessly through the coding and OsCommerce`s help forums but have not found an answer yet. Any help would be greatly appreciated, ================================================== their response: 2checkout has just released some new required parameters for our V2 system that have to do with identifying your products. We have also released a few additional optional parameters. I have included an attachment with more information on this. The attachment New Cart Purchase Parameters It has become necessary for 2Co to know the specific product that is being sold at the time of sale and for that product's description to be stored in our database for reference. This change is required both by 2CO and by our banking partners to better mitigate risk and to monitor items being sold. Because of this requirement, we are asking cart makers and/or users to make changes to their cart or programs so that additional information about the items being sold is passed to 2Co. It is very important to note that: 1. All previous parameters remain supported and should continue to be passed in ( 2Co , Authorize.net ) , 2. The parameter total ( or the authorize.net parameter : x_amount ) passed in for the order will continue to be the amount billed for the sale, 3. The paramaters cart_order_id and sid ( or the authorize.net parameters : x_invoice_num and x_login ) are still manditory with this parameter set. Teal parameters are required to identify cart products being purchased and should be supplied ASAP. For some clients it may make sense to create 1 or multiple generic products in the 2Co db, like "Premium Hosting", "Super Saver Hosting" and pass in a total for the sale as generated on their site. If this option works for you please make the product name reasonably descriptive, (i.e. "website design services" would be a good description, "web services" a poor one for the same item ). Blue parameters are those required for product creation to take place at the time of sale if the product does not already exist in the 2Co system. These parameters are intended for carts that retain no product database or as a transition method of populating the 2Co database. Although it is desirable to receive as many parameters as possible with the purchase the option of creating products on the fly should only be used when no other options exist. REQUIRED PARAMETERS ? c_prod or c_prod_[:digit] : This parameter will contain either the assigned_product_id given to the product upon creation in the 2CO system or a vendor specified id. It may, optionally, also contain the id followed by a ?,? ( ASCII comma ) followed by an integer which will represent the quantity. This parameter should not be autogenerated with each individual sale but should be tied to a specific product. The c_prod value should match whatever external vendor id is recorded in the 2Co system. The external vendor id maybe a cart assigned product id or the vendors own internal product id as long as the value matches the value stored in the 2Co system. o Examples of valid values: ? 1 ? my_product_17 ? product_5,3 ? id_type This parameter will contain an integer value representing the type or classification of the ids used in the c_prod parameter(s). This value will apply universally per transaction. That is to say c_prod parameters must contain only assigned_product_id values or only vendor_product_id values. Current valid values for this parameter are defined as follows. o 1 is defined as vendor_product_id o 2 is defined as assigned_product_id o 3 ? 0 are reserved for future use. OPTIONAL PARAMETERS ? sh_cost (optional) : This parameter will contain shipping and handling cost, if any. The sh_cost parameter is completely optional. This parameter has the same format rules as the parameter containing the total (total or x_amount) that you are currently using. This value received is assumed to be in the selected currency of your 2CO account. o Examples of valid values: 0.50, 5.00, 10 ? c_name or c_name_[:digit] : This parameter is required for new product creation. The value of this parameter should contain the name of the product to be created. It is limited to 128 characters including spaces and punctuation. If the value is too long it will be cut off at 128 characters. ? c_description or c_description_[:digit] : This parameter is required for new product creation. The value of this parameter should contain a short description of the product to be sold. It is limited to 255 characters including spaces and punctuation. If the value is too long this value will be stored as the long description instead. The long description will not show on the checkout pages but it will be saved in the 2Co product database. ? c_price or c_price_[:digit] : This parameter is required for new product creation. This value should reflect the price of the product in your 2CO account selected currency. This parameter has the follow format restrictions o Numbers and decimal point only. o Max value: 999,999.99 ? c_tangible or c_tangible_[:digit] ( optional ) : This parameter is optional. If you do not provide a value for it a default value of Y will be used. This field indicates if the product is a physical product or an e-good/service. This parameter has the following format restrictions: o Valid values: y Y n N ============================================== My Followup question From what I can understand is I`m going to have to add all his products to the 2CO database? ============================================== Their response You are corrects. We need a list of all products that vendors will be offering to customers. This is needed for 2checkout to stay in compliance with new credit card company regulations. Since 2checkout is the authorized reseller of our vendors, customers are actually purchasing products/services directly from 2CO. For this reason, we need all vendors products uploaded into our database. =============================================== so from what I gather what we are going to have to do is rewrite the entire shopping cart contents to show "THEIR" Buy Now button........unless someone out there can figure out a contribution to fix this jumbled up mess......
×
×
  • Create New...