Jump to content

eugeniobonifacio

Members
  • Content count

    22
  • Joined

  • Last visited

Everything posted by eugeniobonifacio

  1. eugeniobonifacio

    Please HELP with Easy Specials !

    v1.3.3 has been released. Get it here. Let me know. Eugenio
  2. eugeniobonifacio

    Please HELP with Easy Specials !

    I'm making some changes. Can you check if the same happens with single product discounting (in the product list)? I think it should be the same, but I need a confirm. Eugenio
  3. eugeniobonifacio

    Please HELP with Easy Specials !

    Let's try this. Go to line 157 in specials.php, or find the following line: if(preg_match("/^(.*)%$/", $discount)) and change it to if(preg_match("/^(.*)(%|p)$/", $discount)) now you are able to pass a percentual discount either with percent "%" or "p" character. So you can apply a percentual discount of 10% in the form "10%" or "10p". Let me know. Eugenio
  4. eugeniobonifacio

    Please HELP with Easy Specials !

    I checked the script and tested it: I cannot reproduce the error you get. In general the 404 error lets me think that it should be a problem caused by your server settings, for example mod_rewrite, or some page authorization script in your osCommerce. There are scripts that help manage access to admin pages, these could cause this kind of problem. Next step should be allowing me direct access to your store. Let me know. Eugenio
  5. eugeniobonifacio

    Please HELP with Easy Specials !

    Hi, can you post here the URL shown in the browser when this happens? This could be a problem caused by mod_rewrite. Are you sure it happens only when applying percentage discount? Do you mean overall or single row discount applying? Let me know about all this. Bye Eugenio
  6. eugeniobonifacio

    Easy csv

    Sorry for my absence. I had subscribed the topic but I've not received updates anymore.
  7. eugeniobonifacio

    Easy csv

    scottybwoy was wrong in doing some customization, he misunderstood the meaning of categories_separator configuration param
  8. eugeniobonifacio

    Easy CVS problem: no name & description

    if your field goes into products table just add it in [products] section inside ini file.
  9. eugeniobonifacio

    Easy CVS problem: no name & description

    Yes, it's different. You must change "nl" to "NL" in your csv_import.ini, under [products_description] section
  10. eugeniobonifacio

    Easy CVS problem: no name & description

    Are you sure your oscommerce language code is "nl"? I remember a similar case like yours where the language code was "ho" not "nl". Check it in admin->localization->languages tip: you can remove unused languages from cvs and csv_import.ini (don't forget columns_headers setting) Let me know.
  11. eugeniobonifacio

    Easy csv

    I started working on a kind of "smart" updating, this should be useful for your case. Meanwhile, in your csv_import.ini, you should comment out 'categories_id' item inside [categories] section using ';' (semicolon) when updating. I hope having been useful.
  12. eugeniobonifacio

    Easy csv

    No, you were close. first of all add this lines to csv_import/csv_import.ini just before [categories] section [price_break] price_break = "x" amount = "x" you must replace 'x' with csv column position (starting from 0) then add the following line in csv_import.php after line 115 (just after the other bindings): $bindings['price_break'] = $config["price_break"]; after line 535 (just after languages insert): tep_db_query("INSERT INTO products_price_break (products_price, products_qty, products_id ) VALUES('" . $data[$i][$bindings['price_break']['price_break']] . "','" . $data[$i][$bindings['price_break']['amount']] . "' ,'" . $product_id ."')"); and, for supporting updates, after line 574 (just after languages update): tep_db_query("UPDATE products_price_break SET products_price = '" . $data[$i][$bindings['price_break']['price_break']] . "', products_qty = '" . $data[$i][$bindings['price_break']['amount']] . "' WHERE products_id = " . $product_id . ""); I didn't test all this changes, there could be some syntax error, but it shoul do what you want. Let me know.
  13. eugeniobonifacio

    Easy csv

    You should edit your csv_import.php and, after a product has been imported, add some code to manage your new fields (also added to ini file) to be added to the price_break tables.
  14. eugeniobonifacio

    Easy csv

    If someone encounters problems with my contribution and wants to contact me about it, it would be very useful if you tell me your PHP/MySQL versions. Thank you
  15. eugeniobonifacio

    Easy csv

    I checked it and all works right. Which version do you refer to? Try the new v2.1.0 Thanks
  16. eugeniobonifacio

    Easy csv

    mmm try to remove @ char in the following line: if($handle = @opendir(CSV_IMPORT_UPLOAD_FOLDER)) { becomes if($handle = opendir(CSV_IMPORT_UPLOAD_FOLDER)) { it should say something more about, i.e. another warning message. Let me know.
  17. eugeniobonifacio

    Easy csv

    Not all tables, this works only for 'products' and 'products_description' tables
  18. eugeniobonifacio

    Easy csv

    At first, actually the latest release is v2.0.3. If the two fields are in PRODUCTS table, then you should add them to config.ini in "products" section: [products] ... cost = 12 availability_id_out_of_stock = 13 You must use the same name in db table About images, yes the script will grab the picture from the specified url then saves it with the name you put so creating a local image. I will take a look at easypopulate as soon as possible, it's not always easy to find some time. Thank you. Let me know.
  19. eugeniobonifacio

    Easy csv

    You were right, i've forgotten to clear those parts of code. Now I cleared and added a configuration option 'allow_empty_db' to enable/disable empty catalog feature (you can empty products's tables). So you should set it to '0'. Categories mapping was an experiment, not needed anymore. You can find the updated version v2.0.2 in osCommerce addons page (http://addons.oscommerce.com/info/4920). Let me know if it's ok.
  20. eugeniobonifacio

    Easy csv

    I know this issue, i'm thinking about solving it. Can you be more clear? I don't know how easy populate works. Sounds strange, in tax_class you can put tax class name (ex 'VAT') or its id, i've tested it and worked. I'll take a look.
  21. eugeniobonifacio

    Easy csv

    Sorry i didn't understand at first time... about images url, i can improve it letting specify name and url, but the the image will be grabbed locally
  22. eugeniobonifacio

    Easy csv

    First of all i suppose you have a right csv file, actually is comma-separated (,), if you don't know this, you can open your csv file with a notepad and look at the character separating the headers (first row). If it's not comma, you can change it in configuration: [csv] ; fields separator delimiter = "," The error you get is due to the mismatch count of the fields in row #5 against the headers count. I'll change this error in more correct : "Row 5: The count of fields is wrong" Sometimes it is due to empty cells in Excel that aren't written in the exported csv file, so you get a different count along the rows of the file. This situation can be handled in configuration file: ; if csv file has different columns count (relative to the first row, i.e. column headers), tries to correct it adding blank fields correct_fields_count = 1 ; max number of fields difference to correct (relative to the first row, i.e. column headers) correct_fields_radius = 3 try to change the radius value, it's the maximum mismatch tolerance. Outside this value you get a mismatch error. The second question is sbout the images url. You can put an URL inside the image field of your csv file, in this case (supposing you have the CURL PHP library installed, you should) your image will be grabbed and put inside the images folder. The resulting name of this image is the same of the remote one. Let me know if you solved, and thanks for your persistence.
×