Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

pirosaint

Members
  • Content count

    21
  • Joined

  • Last visited

About pirosaint

  • Birthday 08/29/1973

Profile Information

  • Real Name
    Ignacio Orellana
  • Location
    wappingers Falls
  • Interests
    Cine, Mp3s, Flash 8, Php
  • Website
  1. Hi can anyone tell me please.. how to verify if that table is not on the sql.. using another method.. i already went to it and it seems that is there, but when i ran the oscommerce is telling me that is not how can i make sure that i am doing the right thing thanks in advance for your comments nch
  2. yes i did and it had a blank space but i removed it so i dont know what else could be any extra idea?? thanks for your support nch
  3. Hi thanks for heads up, but this is what i got from the sql.. after i ran what i suppossed to: ALTER TABLE `orders` ADD `account_name` VARCHAR( 32 ) NOT NULL AFTER `currency_value`; ALTER TABLE `orders` ADD `account_number` VARCHAR ( 20 ) AFTER `account_name`; ALTER TABLE `orders` ADD `po_number` VARCHAR ( 12 ) AFTER `account_number`; this is the pic: and after that this is the table "Orders".. last part of it: any idea.. i am not good with sql.. but i think here says that somehow the table is duplicate... but when we are at the catalog and we press the confirm button, there it says that we are missing that "account_name" on the table.. how is that works?? thanks very much for your help nch
  4. Hi after installed the Purchase Orders version 1.3, i got this error in the end of the process, after i click the confirm button.. am i missing something.?? any comments will be highly appreciate it. nch
  5. pirosaint

    Seperate Pricing Per Customer v3.5

    //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// THANK YOU - THANK YOU - THANK YOU - THANK YOU - THANK YOU - THANK YOU - THANK YOU - THANK YOU Y O U A R E A W E S O M E!!! Y O U A R E A W E S O M E!! Y O U A R E A W E S O M E!!! //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// you don't how good it feels... it was endless.. ok now is working what i wanted it thanks very much. next step.. but its diferent thing... 1.- the main category has all the products and order... Ceiling Fans - - Manufacturer 1 - line 1 prod 1 prod 2 prod 3 - line 2 prod 1 - - Manufacturer 2 - line 1 prod 1 prod 2 - line 2 prod 1 prod 2 prod 3 - line 3 prod 1 - - Manufacturer 3 - line 1 prod 1 prod 2 prod 3 - line 2 prod 1 prod 2 - line 3 prod 1 prod 2 prod 3 - line 4 prod 1 prod 2 prod 3 so.. 2.- how can i create a drop down list under the of the main categories. regarding a for example... assigning a special category, but from diferent manufacturers. we are saying.. Ceiling Fans for: - Bath Manufacturer 1 - prod 1 Manufacturer 4 - prod 2 Manufacturer 4 - prod 1 Manufacturer 8 - prod 7 - Living Room Manufacturer 1 - prod 1 Manufacturer 4 - prod 1 Manufacturer 10 - prod 4 Manufacturer 12 - prod 3 - Bed Room, etc... Manufacturer 1 - prod 1 Manufacturer 4 - prod 2 Manufacturer 10 - prod 1 Manufacturer 12 - prod 7 well nothing else beside to say again thank you i hope theres is something to use for this.. nacho pd: but i did never understand how make that sppc contribution work.. so i will ask for that some day soon... \m/ keep on rockin'
  6. pirosaint

    Seperate Pricing Per Customer v3.5

    thanks for your answer, ok so i will download the new contribution that you said, but there are many of them.. i mean.. - Percent Saved Only eficker 13 Jan 2006 - Percent saved update eficker 12 Jan 2006 - Added: % saved eficker 11 Jan 2006 - Display MSRP & Savings ( i will work on this one by now) thanks again, so what do i do with all those codes that we put before??? nacho
  7. pirosaint

    Seperate Pricing Per Customer v3.5

    hi you doing oscommerces...!!! well... this is madness i really dont know how you guys do this.. so im gonna keep praying.... for help no sleep... no eat... frustration is what i feel after tryied everything i know, and i been helped by really good people (janZ), but it's me.. i just dont know... i feel sorry for me.. well...focus.. patience //////////////////////////////////////////////////////////////////////////////////////////////////c in one hand i have on the catalog.. the two diferents instances of prices ( but one with out the $00.00), i just can't make it work properly(appear) and also neither make the change.. (one is greater that the other.) here is the pic: ///////////////////////////////////////////////////// in the other hand, i have the admin section... on the customer groups... i have this letters without defining i guess (where do i make the right define to make them right?) here is the pic: /////////////////////////////////////////////////////////////////////////// the idea is to get on the catalog two prices... - manufacturer Price: (suggedted by them) - our price: (our selling price) how can this contribution do this.. ? maybe because is not working properly i couldnt get to see it but im completely lost... anybody help??????????????????????? thanks for your time nacho
  8. pirosaint

    Seperate Pricing Per Customer v3.5

    Hello !!! Oscommerces !!! First of all i'd like to thanks to JanZ, for his kindly help on my store's problems, this piece of work is the most amazing thing for the whole oscommerce.. project with alll the other contribution of course.... \m/ you guys rocks!!! but.. still i got some question i know more Flash than Php and maybe some other member had the same problem.. as me.. so.. this is the thing.. Here there's a pic of the admin, if you see there is no a customer group to choose from, and JanZ said that maybe i didnt upload the customers_goups.php to my site, but in fact i didnt see it on any contribution that i used... so anyone of you know wichone would be that file that i missing... beacuse i really have no idea about it... so now on the store, you can see two prices - manufacturer price= -- - our price= -- but both are the same and i can't change them, and also i can't not create another cusatomer group and second place what is the code that you use to make those links.., i mean to make them appears on the page.. thanks very much again to all. nacho www.lightguy.com It doesn't show the link in the box, but if you uploaded all the files in the admin you should have uploaded that file: customers_groups.php. Adding the link to it is one of the first things that is mentioned in the new_install_directions.txt to change in the file: catalog\admin\includes\boxes\customers.php So try typing in http://yoursite/admin/customers_groups.php and see if you can find it there, then you only need to add the link to the box customers.php Kind regards, Jan
  9. pirosaint

    Seperate Pricing Per Customer v3.5

    It doesn't show the link in the box, but if you uploaded all the files in the admin you should have uploaded that file: customers_groups.php. Adding the link to it is one of the first things that is mentioned in the new_install_directions.txt to change in the file: catalog\admin\includes\boxes\customers.php So try typing in http://yoursite/admin/customers_groups.php and see if you can find it there, then you only need to add the link to the box customers.php Kind regards, Jan
  10. pirosaint

    Seperate Pricing Per Customer v3.5

    hey.. hi can you tell me what was that solution for the groups on the admin??? thank you very much nch
  11. pirosaint

    Seperate Pricing Per Customer v3.5

    Hi everyone...!!! im nacho and i was trying to do thing work beacuse it just what i need and, after do all the steps i have this two error on my store now.. on the mysql query : // Error SQL query: ALTER TABLE `customers` ADD `customers_group_name` CHAR( 27 ) DEFAULT 'Retail' NOT NULL , ADD `customers_group_id` INT( 11 ) DEFAULT '0' NOT NULL ; MySQL said: Documentation #1060 - Duplicate column name 'customers_group_name' // and also on the store when you press over any product: // select customers_group_price from TABLE_PRODUCTS_GROUPS where products_id = '595' and customers_group_id = '' [TEP STOP] // any of you have any i dea about tthis??? im not that good with sql... but i think that something is repeating here or something.. thge site is this: http://www.lightguy.com well thanks very much to all of you nacho
×