Jump to content

Kestas

Members
  • Content count

    36
  • Joined

  • Last visited

Posts posted by Kestas


  1. Please any one help me..

    I do in a-b-c way, xls have some additional information, like formats, column withs, etc., but not need in this case. I think, that there is excel limitation to 256 or like columns. Rest of columns are truncated, so there no product end symbol.

    Try use text editor for edit .csv files. Exclude atributes from importing, or exclude some of atributes to pass excel max column numbers by grouping products in small groups. Maybe there are other ways. I'm novice, I have anothers problems, but there many posts not ansvered...


  2. hi all,

     

    I am new to OsCommerce. I have installed Easy Populate 2.76f-MS2.

    The Products export to excel (from database to csv file) is woking fine.

    Then i do some modification in that csv file. Then i upload that file to database i had following error

    "1366 - Incorrect decimal value: 'v_attribute_values_name_13_17_2' for column 'products_price' at row 1

     

    INSERT INTO products ( products_image, products_model, products_price, products_status, new_arrivals, homepage_products, featured_items, products_last_modified, products_date_added, products_date_available, products_tax_class_id, products_weight, products_quantity, manufacturers_id ) VALUES ( 'v_attribute_values_name_13_17_1', 'values_name_13_14_3', 'v_attribute_values_name_13_17_2', '1', 'No', 'No', 'No', '2008-01-07 05:00:02', '1970-01-01 00:00:00', '1970-01-01 00:00:00', '', 'v_attribute_values_price_13_17', 'v_attribute_values_name_13_17_3', NULL) "

     

    Note : I had many product attributes, so the CSV file has many column from A, B, C... ENU.

     

    I think that, due to many columns in the CSV file the it take header as the value. Actually 'v_attribute_values_name_13_17_1' is a header not a value but pls see the error message it coe under values. I think that EP has some limitations for coloumn count after it over the limitation it take the header as a value. I am not sure about these..

     

    Please any one help me i would like to solve this issue as soon as possible.

     

    Please help me.

    Check decimal symbol, must be "." (dot). I have comma in regional settings, so every time use replace function in excel for price and weigh columns, before save .csv.


  3. Hi,

     

    I needed the similar thing. You only need to modify the $listing_sql at index.php that was modified by this contrib.

     

    Find this

    $listing_sql = "select distinct " . $select_column_list . " p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, 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 from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and " . $cat_Search . "";

     

    And replace with this

     

    $listing_sql = "select distinct " . $select_column_list . " p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, 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, cat.categories_id as catid, cat.categories_image, catd.categories_id as catd_id , catd.categories_name from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p, " . TABLE_CATEGORIES . " cat, " . TABLE_CATEGORIES_DESCRIPTION . " catd left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and " . $cat_Search . " and cat.categories_id = p2c.categories_id and catd.categories_id = p2c.categories_id and catd.language_id = '" . (int)$languages_id . "' "; 

    This will add the categorie name and image. You can remove the other id's since i only used them for checking.

    not working for me :( got error on index.php:

    1054 - Unknown column 'p.manufacturers_id' in 'on clause'

     

    select count(distinct p.products_id) as total from products_description pd, products p, categories cat, categories_description catd left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id, products_to_categories p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '4' and (p2c.categories_id = '50' or p2c.categories_id = '51' or p2c.categories_id = '52' or p2c.categories_id = '53' or p2c.categories_id = '21') and cat.categories_id = p2c.categories_id and catd.categories_id = p2c.categories_id and catd.language_id = '4'


  4. Kestas, I am not sure what your asking about the breadcrumb. The problem you are seeing is what I had prior to the change in the product_listing.php. If you dont make that change, you will have the issue where the breadcrumb doesnt change. Like I've said before, the mod will work with only the index.php edits, but you'll end up with a breadcrumb bug if you dont do the product_listing.php changes.

     

    It is this section of the product_listing.php which controls that

    ($cPath ? 'cPath=' . $cPath . '&' : '') .

    it was actually showing the breadcrumb from where you clicked, rather than where the product was. So removing that little bit solved that issue. The only drawback to removing this from the product_listing.php is that if you have a product listed in multiple categories (copied), when that product is clicked in the product listing, the breadcrumb will show it in the original category it was listed in rather than the current category path by default.

    When I modify product_listing.php I have no products in listing and right column is missed, there is bug.

    You are right for $listing_sql = "select distinct ", but in contribution missed space after distinct.

    I close eyes for breadcrumb bug for now, but will return later.

    Thank You for support :)


  5. How to tell EP that not divide field beetween quotes, when html tag are inside quotes with semi-colon?

    Now EP divide field after first quote symbol, as in previous my post. Result is divided field, when html tag   are inside field.

     

    PHP Version: 5.2.5 (Zend: 2.2.0)

    Database: MySQL 5.0.45-community-log

    Settings

    EP vers: 2.76f-MS2 r1

    Temp Dir:

    /home/zaislai/domains/mydomain.lt/public_html/test/temp/

    Temp Dir is Writable

    Magic Quotes is: off

    Split files on: 300 records

    Model Num Size: 12

    Price with tax: false

    Calc Precision: 2

    Replace quotes: false

    Field seperator: semi-colon

    Excel safe output: true

    Preserve tab/cr/lf: false

    Category depth: 7

    Enable attributes: true

    SEF Froogle URLS: false

    More Pics: false

    Unknown Pics: false

    HTC: false

    SPPC: false

    Extra Fields: false

    I have last EP vers: 2.76f-MS2 r1 on MS2.2rc1. In products description are non english characters, like ąčęėįšųūž. In descriptions after importing csv first and/or last character are truncated.

    After I add UmlauteBugFixDescription (German Umlaute - Fix-Description) descriptions not truncated, but quotes are doubled in descriptions after importing csv.

    In all cases I export csv file, leave 1-2 products on it (on text editor) and import same file back.

     

    I replaced qoutes with right qoutes in my products description, so no more quotes bug when UmlauteBugFixDescription aplied.

     

    If any have this problem or have solved, please leave your comments here.


  6. i found the solution :

    replace

    // We show them all
    	$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, 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 from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p2c.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'";
      }
    }

     

    with

    // We show them all
      $cPathA = explode("_", $cPath);
      $size = sizeof($cPathA)-1;
      $subcategories_array = array();
      tep_get_subcategories($subcategories_array, $cPathA[$size]);
      $size_sc = sizeof($subcategories_array); //Subcat count
      $cat_Search = "(";
      for($i = 0; $i < $size_sc; $i++){
      $cat_Search .= "p2c.categories_id = '" . $subcategories_array[$i] . "' or ";
      }
      $cat_Search .= "p2c.categories_id = '" . $cPathA[$size] . "'" . ")";
    
      $listing_sql = "select " . $_list . " p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, 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 from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and " . $cat_Search . "";
      }
    }

    Thank You osclearner, now workink but there need small improvement.

    2 theantiquestore: I have original index.php and product_listing.php from v2.2rc1

     

    Now breadcrumb displayed

    catalog>>category>>model
    when I click product detal page even product is in main category or subcategory. I think, that more logical will be displaying
    catalog>>category>>subcategory>>model
    in case above, like in case navigating category > subcategory > item. This is intuitive way go back to subcategory by click on subcategory on breadcrumb. So subcategories in menu works like filter.

    If I use search and after click to go to product page, than I have full breadcrumb path like

    catalog>>category>>subcategory>>model
    .

    Maybe we need adopt search queries for display products with full breadcrumb.


  7. theantiquestore:

     

    i copied and pasted the file u pm' me and it gets error 1054, if the index.php file is ok, is this problem caused by includes/modules/product_listing.php? because i didnt change anything on this file , i showed it to u in the above reply of this topic cause there are some different lines, i dont know how to change it.

     

    can you help me to take a look at product_listing.php and tell me how to change it ?

     

    thank you very much

    I also got error, so leave original product_listing.php, because modifications buggy on this file. And index.php has breadcrumb bug.

     

    Contrib for great future, but buggy.


  8. Hello all,

     

    I just intalled this great module (order_editor_5_0_6), but have folowing bug:

    When I add product to order in selection popup window I have categories, names in my lithuanian language, but after I submit "add to order" - on order is english product name.

    It's ok with english language on admin - all in english on popup selection, on order.

    I have 2 languages on my store.

     

    How resolve it?

    I know, I can manualy rename product, but...


  9. Any help please ??
    I think You can use product model as manufacter model and You hide model listing by admin and edit product_info.php page.

    Also You can add more columns for products, rewrite EP module for additional rules synchonization and leave alone with problems and errors. Sorry, but on this forum I had no answered my problems with standard EP module problems, so modification is bad way except if You are hard coder.


  10. Problem with importing. I have exported to .csv and same file imported back. Products, description was truncated. there is example of exported file

    and same product (realy not same, but result of importing) exported

    I see that html tag in file description imported non accurate. Semicolon after divided description to sepatates columns, but it was inside quotes. And second: description first letter was lost: Žaidimas.

    I use 2.76f-MS2 r1 and UmlauteBugFixDescription aplied

    How to tell EP that not divide field beetween quotes, when html tag are inside quotes with semi-colon?

    Now EP divide field after first quote symbol, as in previous my post. Result is divided field, when html tag   are inside field.

     

    PHP Version: 5.2.5 (Zend: 2.2.0)

    Database: MySQL 5.0.45-community-log

    Settings

    Temp Dir:

    /home/zaislai/domains/mydomain.lt/public_html/test/temp/

    Temp Dir is Writable

    Magic Quotes is: off

    Split files on: 300 records

    Model Num Size: 12

    Price with tax: false

    Calc Precision: 2

    Replace quotes: false

    Field seperator: semi-colon

    Excel safe output: true

    Preserve tab/cr/lf: false

    Category depth: 7

    Enable attributes: true

    SEF Froogle URLS: false

    More Pics: false

    Unknown Pics: false

    HTC: false

    SPPC: false

    Extra Fields: false


  11. Problem with importing. I have exported to .csv and same file imported back. Products, description was truncated. there is example of exported file

    121;Šaškės;" Žaidimas ""Šaškės"", kieta lenta. Dydis 330x0,5x175 mm.";;Chekers;" Game ""Checkers"". Size 330x0,5x175 mm.";;games/saskes.jpg;5.7034;0;0.58;;2004-10-29 13:02;....

    and same product (realy not same, but result of importing) exported

    "121";"Šaškes";""" ";"aidimas """"Šaškės"""", kieta lenta. Dydis 330x0,5x175 mm.";"";"CHekers";""" ";"Game ";"0";"1";"0.00";"1970-01-01 02:00:00";"2007-10-26 08:05:12";"0";...

    I see that html tag in file description imported non accurate. Semicolon after   divided description to sepatates columns, but it was inside quotes. And second: description first letter was lost: Žaidimas.

    I use 2.76f-MS2 r1 and UmlauteBugFixDescription aplied


  12. Bug fix - osCommerce PayPal IPN Module v2.3.2 For 2.2MS2

     

    Problem - In v2.3.2 if set 'Display Prices with Tax' to true in admin under configuration->My Store and set 'Transaction Type' to 'Per Item' in PayPal IPN module settings, the shipping tax would be added a second time and caused the total amount sent to PayPal to be larger.

     

    How to fix - find in catalog/includes/modules/payment/paypal_ipn.php (v2.3.2) around line 412:

    		if ($tax_total > $item_tax) {

    Replace with:

    		if ($tax_total > $item_tax && DISPLAY_PRICE_WITH_TAX != 'true') {

    That's it.

    Thats fix works fine: no more double tax of shipping costs (I have line 421 on paypal_ipn.php)!

     

    Another question:

    Why paypal form filled with Shipping Address data (name, address), why not Billing Address? If customer have order to delivery to another address than billing, and try to change address in paypal, than got error:

    The merchant has requested a specific address. You may not use a different address

    Second, on paypal completed payment page is "Your order is being shipped to" billing adress same as above.

    Maybe there is ansver on my question.

    But why need billing address in store? Do paypal need customer billing address declared for card issued bank for card autorization? OR delivery address for shipment verifing?

     

    I remember on some internet purchases (not paypal) on card paying forms requirement fill address from card issued bank (I think to prove identity additionaly).


  13. I have tested v2.3.2 on sandbox. All calculation works right.

    MANY THANKS for AlexStudio

    About encoding problems:

    If shipping adress fields have non english letters, than error ocour:

    You have entered unsupported characters for this field. Current available language character types are: European, Chinese, Korean, Japanese, and Thai. Please try again.

    If I go continue to pay with card, than name and/or surname are not filled. I tested with different paypal and store (paypal_ipn.php) charsets.

    I go to transcoding non english characters, I foud on this forum post


  14. After I changed from v2.2 to this v2.3.1 I got tax (VAT) added twice, so orders total bigger on paypal, than on store. Calculation was good on v2.3. Others settings no change when update from v2.2 to v2.3.1

    This problem is only when Transaction Type: Aggregate

    No problem with total calculation when Transaction Type: Per Item


  15. osCommerce PayPal IPN Module v2.3.1 For 2.2MS2 released. Download here.
    • Bug fix - In v2.3 when "Display Prices with Tax" set to true under admin configurations, the handling amount become negative and causes the error message "PayPal system contains an incorrectly formatted packing value" issue. Fixed by adding a configuration key checking when calculating handling amount.
    • Bug fix - In v2.3 The shipping/handling amount could have discrepancies when 'Per Item' mode selected. Re-wrote the shipping/handling calculation so the amounts are now accurate.
    • Bug fix - If the order content type is 'virtual', the customer's billing address should be sent to PayPal instead of the delivery address.
    • Added post v2.2 multi-language support fix by Terra.
    • Added 'Per Item' mode supported when Encrypted Web Payments is enabled.

    After I changed from v2.2 to this v2.3.1 I got tax (VAT) added twice, so orders total bigger on paypal, than on store. Calculation was good on v2.3. Others settings no change when update from v2.2 to v2.3.1


  16. Hi AlexStudio,

    I installed v2.3.1 on my 2.2MS2, but when i'm arrive on Paypal site, i have this message: "You have entered unsupported characters for this field. Current available language character types are: European, Chinese, Korean, Japanese, and Thai. Please try again."

    I think it's because i have special chars (french products whit accents) in my items name.

    Is it possible, and where, to filter this special char ? For example we can transform them whitout accents.

    Thanks in advance for your answer.

    Regards,

    Jerome

    I have special chars in account Name (Billing adress without these, as on card) and same message on paypal. But with this message is possible pay and complete order (on sandbox). So I also interested in filter for transcoding names, items and remove special characters (like ąčęėįšųūž)

     

    I have tested v.2.2 and v.2.3

×