Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

cobyone

Members
  • Content count

    11
  • Joined

  • Last visited

  1. I posted this as a thread under General Contribution Support before I noticed that there was a continuing thread for support for Easy Populate. My apologies for the double up. Hi there, OS Commerce v2.2 RC2a Easy Populate 2.76h-MS2 Everything has been working for a long time, then last week I did an upload and saw that it had changed all the products (affected by the import) to have a price of $0.00. I restored the database and have been searching through code for a week, but still can't find out how this started happening. The prices are correct in the EP file The prices are correctly displayed in the post-import results on easypopulate.php (see below) The price can be edited (restored) using phpMyAdmin with no problems. Nothing has changed in easypopulate.php Does the same thing with 2500 products, and does the same when importing only 1 product. The temp folder has appropriate permissions. Here is an example of what result I get from easypopulate.php after doing a test upload for a few products: File uploaded. Temporary filename: /tmp/phpSEjmzc User filename: sagemtest.txt Size: 4698 | OEM 232835 | Sagem | Fax Suppli | faxfilm.jp | | | Sagem Genu | Original | Product: S | | $31.10 | Active Updated | OEM 232915 | Sagem | Fax Suppli | faxfilm.jp | | | Sagem Genu | Original | Product: S | | $144.20 | Active Updated | OEM 232915 | Sagem | Fax Suppli | faxfilm.jp | | | Sagem Genu | Original | Product: S | | $223.95 | Active Updated | OEM 233277 | Sagem | Fax Suppli | faxfilm.jp | | | Sagem Genu | Original | Product: S | | $116.90 | Active Updated | OEM 236601 | Sagem | Fax Suppli | faxfilm.jp | | | Sagem Genu | Original | Product: S | SAGTBR36.j | $194.25 | Active Updated | OEM 236601 | Sagem | Fax Suppli | faxfilm.jp | | | Sagem Genu | Original | Product: S | SAGTNR736. | $238.70 | Active Updated | OEM 236902 | Sagem | Fax Suppli | faxfilm.jp | | | Sagem Genu | Original | Product: S | SAGTTR900. | $47.40 | Active Updated | OEM WL3400 | Sagem | Fax Suppli | faxfilm.jp | | | Sagem Genu | Original | Product: S | | $262.15 | Active Updated | OEM WL3400 | Sagem | Fax Suppli | faxfilm.jp | | | Sagem Genu | Original | Product: S | | $199.95 | Active Updated | OEM 236598 | Sagem | Laser Cart | lasercartr | | | Sagem Genu | Original | Product: S | | $385.00 | Active Updated And yet those prices don't actually go into the products!!! They wind up as $0.00! Any ideas or suggestions would be greatly appreciated.
  2. Hi there, OS Commerce v2.2 RC2a Easy Populate 2.76h-MS2 Everything has been working for a long time, then last week I did an upload and saw that it had changed all the products (affected by the import) to have a price of $0.00. I restored the database and have been searching through code for a week, but still can't find out how this started happening. The prices are correct in the EP file The prices are correctly displayed in the post-import results on easypopulate.php (see below) The price can be edited (restored) using phpMyAdmin with no problems. Nothing has changed in easypopulate.php Does the same thing with 2500 products, and does the same when importing only 1 product. The temp folder has appropriate permissions. Here is an example of what result I get from easypopulate.php after doing a test upload for a few products: File uploaded. Temporary filename: /tmp/phpSEjmzc User filename: sagemtest.txt Size: 4698 | OEM 232835 | Sagem | Fax Suppli | faxfilm.jp | | | Sagem Genu | Original | Product: S | | $31.10 | Active Updated | OEM 232915 | Sagem | Fax Suppli | faxfilm.jp | | | Sagem Genu | Original | Product: S | | $144.20 | Active Updated | OEM 232915 | Sagem | Fax Suppli | faxfilm.jp | | | Sagem Genu | Original | Product: S | | $223.95 | Active Updated | OEM 233277 | Sagem | Fax Suppli | faxfilm.jp | | | Sagem Genu | Original | Product: S | | $116.90 | Active Updated | OEM 236601 | Sagem | Fax Suppli | faxfilm.jp | | | Sagem Genu | Original | Product: S | SAGTBR36.j | $194.25 | Active Updated | OEM 236601 | Sagem | Fax Suppli | faxfilm.jp | | | Sagem Genu | Original | Product: S | SAGTNR736. | $238.70 | Active Updated | OEM 236902 | Sagem | Fax Suppli | faxfilm.jp | | | Sagem Genu | Original | Product: S | SAGTTR900. | $47.40 | Active Updated | OEM WL3400 | Sagem | Fax Suppli | faxfilm.jp | | | Sagem Genu | Original | Product: S | | $262.15 | Active Updated | OEM WL3400 | Sagem | Fax Suppli | faxfilm.jp | | | Sagem Genu | Original | Product: S | | $199.95 | Active Updated | OEM 236598 | Sagem | Laser Cart | lasercartr | | | Sagem Genu | Original | Product: S | | $385.00 | Active Updated And yet those prices don't actually go into the products!!! They wind up as $0.00! Any ideas or suggestions would be greatly appreciated.
  3. cobyone

    Seperate Pricing Per Customer v3.5

    Hrmm... I went through it with a fine tooth comb as per changes instructions, but still would do the exact same problem. then i decided i'd download one of the older versions of the admin/categories.php file, so i downloaded the 4.1.1 package and made the changes to admin/categories.php as per the older version - uploaded it and it seems to have fixed the problem straight away. not sure exactly how this happened - but i made the original changes *exactly* as per the instructions and using winmerge. The current version instructions may include (or leave out) something that isnt 100% correct, or i simply may be a little less competent than i previously thought lol :blush: , but whatever it is, the older version of the changes to the file seems to have solved my problem. hope this helps someone else in the future.
  4. cobyone

    Seperate Pricing Per Customer v3.5

    Yeah thats the only real conclusion i can come to myself - When I did it I used Compare & Merge like it said in recommended in the instructions, but I will have a go restoring the backup of admin/categories.php and then re-editing that file with WinMerge like you suggest. Thanks for your reply. +Coby+
  5. cobyone

    Seperate Pricing Per Customer v3.5

    Hi there, Firstly I would like to apologise if this issue has already been adressed somewhere else, but I've searched as much as I can without being able to come across a solution for my problem. I'm using OSC 2.2 with SPPC v4.1.5 I installed SPPC fine and its all working with no errors (there were one or two files with an unexpected '}' character in the code but thats all, nothing major), and i can manage customers/groups and their details. however when i'm in the admin/categories page and im editing the product details, no matter what price i put into the field, it will result in changing the price for that customer group to $0.00 if i go into phpMyAdmin and manually insert the correct data to the database in the products_groups table then it displays all the correct pricing on the live site, and when i go back to edit the product details the price is listed there, but clicking on 'preview' on the product information page will reset the group pricing for that product to $0.00 - and this change is instantly visible in the live storefront. so even if i simply wanted to update the description of a product, editing anything on the details page in the admin section will reset it's price for any product group to zero. this means that everytime i make any change to a product whatsoever that i have to go into phpMyAdmin and re-upload all the group pricing form the products_groups table. as you can imagine this is very frustrating 'caus there doesnt seem to be anything actually wrong with any of the code, in that there are no errors being displayed and that all the right fields are in the right forms and such. i followed the installation instructions very closely and while im no *expert* in php, i can debug most of the stuff provided its not too complex - but seeing as there is no error as such i dont even have anything to work with with my limited debugging skill . has this issue come up before? or have i missed something blatantly obvious? or does anyone have any tips on where i could look to solve or find a solution to this problem? any help would be greatly appreciated. +Coby+
×