Jump to content

pleasureidea

Members
  • Content count

    28
  • Joined

  • Last visited

Everything posted by pleasureidea

  1. pleasureidea

    The Feedmachine Solution

    I don't think you can connect using the same settings. Try to duplicate the bing file and rename it to filezilla file. Also I am not sure if filzilla takes the same feed as bing does.
  2. pleasureidea

    The Feedmachine Solution

    Lech, I am trying to upload bing feed and got response from them that the file is not converted to UTF-8. By opening the file in notepad++ I see the file is encoded in unix and after I encode it manually to UTF-8, everything looks good. The question why it is not converting while I see the config have encoding set up it correctly. Could you tell me what is wrong ? Here is the bing-simple.php file: <?php $feed_config = array('name' => 'Bing Product Search Simple Configuration', 'authors' => 'Lech', //list of authors 'filename' => 'bingshopping.txt', //default feed filename (this can be over-ridden by the user in the admin section) 'schema_version' => '2.0', //always set as '2.0' - this is set just to future-proof configurations in case the schema ever changes //the following section of the feed configuration is the most important. It determines the fields that are output. 'fields' => array('MPID' => array('output' => 'products_id', 'type' => 'DB' ), 'Title' => array('output' => 'FM_UF_fc_manufacturer_and_product', 'type' => 'FUNCTION', ), 'Brand' => array('output' => 'manufacturers_name', 'type' => 'DB', 'options' => array('STRIP_HTML', 'HTML_ENTITIES', 'STRIP_CRLF') ), 'MPN' => array('output' => 'products_model', 'type' => 'DB' ), 'UPC' => array('output' => 'products_upc', 'type' => 'DB' ), 'ProductURL' => array('output' => 'PRODUCTS_URL', 'type' => 'KEYWORD' ), 'Price' => array('output' => 'FINAL_PRICE', 'type' => 'KEYWORD' ), 'Description' => array('output' => 'products_description', 'type' => 'DB', 'options' => array('STRIP_HTML', 'HTML_ENTITIES', 'STRIP_CRLF') ), 'ImageURL' => array('output' => 'IMAGE_URL', 'type' => 'KEYWORD' ), 'MerchantCategory' => array('output' => 'CATEGORY_TREE', 'type' => 'KEYWORD', 'options' => array('STRIP_HTML', 'STRIP_CRLF') ), 'Condition' => array('output' => 'new', 'type' => 'VALUE' ), 'B_Category' => array('output' => 'Home Furnishings', 'type' => 'VALUE', ) ), 'add_field_names' => true, //whether to add header row in the feed with the field names 'seperator' => "\t", //the field separator in the feed. (For tab-delimited feeds this should be "\t". For csv feeds this should be ",") 'text_qualifier' => '', //the character with which to encapsulate field values. (For tab-delimited feeds this should usually be empty, i.e. ''. For csv feeds this should usually be '"') 'category_tree_seperator' => ' ', //the separator to use for the 'CATEGORY_TREE' KEYWORD (see the 'KEYWORD Field Type' section in the notes below) //usually you will not need to worry about the following settings and can leave them as they are 'newline' => "\n", 'encoding' => 'utf8', //'utf8' or false for standard encoding 'currency_decimal_override' => false, 'currency_thousands_override' => '', 'include_record_function' => '' //(optional) specify a function that determines whether the product should be included in the feed ); function FM_UF_lm_stock_check($product) { return $product['products_quantity'] > 0; } function FM_UF_fc_manufacturer_and_product($product) { return $product['manufacturers_name'] . ' ' . $product['products_name']; } ?>
  3. pleasureidea

    getting 'easy' csv import to work

    Hello! The problem appears with thumbnail images when the image name have + (pluses) in name. Thumbnail will not show up but when you click on it, the regular popup image appears. Looks like get_image_from_url function must be corrected somehow. I also use 'On The Fly' Auto Thumbnailer using GD Library 2.1 contribution. Please help me to figure out this. Here is the function: function get_image_from_url($url, $filename) { if(function_exists('curl_init')) { $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_HEADER, 0); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); $out = curl_exec($ch); curl_close($ch); if($out === false) { return false; } if($handle = fopen(DIR_FS_CATALOG_IMAGES . $filename, 'wb')) { fwrite($handle, $out); fclose($handle); } return true; } csv_import_message(CSV_CURL_MISSING_CANT_IMPORT_REMOTE_IMAGE, 'warning'); return false; }
  4. The problem happens when image is not loaded using regular way via admin add new product but when you upload products in bulk using CSV loader. Images like 123+3+3.jpg will not showed as thumbnail. The regular 123+3+3.jpg image exists and when you click on thumbnail it will pop up. Looks like the problem appears only when pluses are in the file name. All other pictures seems to be shown correctly. If you go than and reload the image using admin edit product function, the thumbnail appears. Anybody know how to fix the problem? Please help as now many of my thumbnail pictures with pluses are not shown :(
  5. pleasureidea

    Quick Price Updates - official support

    Looks like the error with "select manufacturers_name from manufacturers where manufacturers_id=" happens when one or more products has no manufacturer assigned in DB. Is there anybody can help to make code corrections, so it will be also working without manufacturer assigned? I have products with manufacturers and without. When the correct manufacturer chosen, everything works just fine. When "all manufacturers" chosen the "select manufacturers_name from manufacturers where manufacturers_id=" error happens. Your help is appreciated. Regards, Oleg
  6. pleasureidea

    Official PayPal IPN Support Thread

    Alex, Is there anyway you can post your ipn.php file into contribution area or post it here? I am so confusing about putting code. Every time when I put // START HTML Invoice if (EMAIL_INVOICE == 'true') { require(DIR_WS_MODULES . EMAIL_INVOICE_DIR . FILENAME_EMAIL_INVOICE); } else { // END HTML Invoice and // START HTML Invoice } // END HTML Invoice I am either getting error in functions\general.php or getting plain text invoice again :( Appreciate your help. Kind regards
  7. pleasureidea

    Official PayPal IPN Support Thread

    Great! I will try to match it. Thank you very much for your great job for community.
  8. pleasureidea

    Official PayPal IPN Support Thread

    Mister Alex, May be you know. Is there anyway invoice that sent to customer can use html form from the contribution that I have installed: http://www.oscommerce.com/community/contributions,2861 Now customers getting plain text invoices if they using PAYPAL check out and HTML fancy invoices - if they use any other payment method. Thank you in advance. Kind regards...
  9. pleasureidea

    New Google Sitemap Generator

    I have a warning in google sitemaps (categories and products) folder saying "Sitemap begins with a space". They have added sitemaps but recommended to fix it to be with a standard XML. I didn't find any spaces here echo '<?xml version="1.0" encoding="UTF-8"?>' . "\n"; Thank you for answers.
  10. pleasureidea

    OSC-Affiliate

    Hello guys! Is there any chance I can get a full categories path with subcategories in catalog/affiliate_validcats.php I am getting now only my end subcategory in Category List but I need like Category/Sub-Category/Sub-Sub-Category Thanks everybody for help.
  11. pleasureidea

    [CONTRIBUTION] Ultimate SEO URLs v2.1 - by Chemo

    Is there any way to have this "....-c-35_359.html" rewrite like this "-c-35-359.html" I was trying different was and did not get any result. Help please who knows. Thank you.
  12. I have installed your great contribution and it works great for customers who have an account. If customer using PWA places an order, it will newer show mismatch. Please help me on this. Thanks.
  13. pleasureidea

    Fancier Invoice & Packingslip v1.0

    When you manually update order status to the processing or shipped... should customer recieve the fancier look or the OSC look of e-mail being sent to him? I have this question since I have installed the Package Tracking with Email Notification Mods http://www.oscommerce.com/community/contributions,3381 When I update the order status my customer receive OSC default e-mail. Thanks for any response.
  14. pleasureidea

    Fancier Invoice & Packingslip v1.0

    Check your settings at admin side/cofiguration/e-mail options Send HTML or Text Invoices to Customers: true Default E-Mailed HTML Invoice Template: html_invoice.php
  15. pleasureidea

    Fancier Invoice & Packingslip v1.0

    I have done it!!! For those who whant to change: This is original code: <?php if (tep_not_null($order->info['cc_number'])) { $this->cc_card_number_less_middle_digits = substr($order->info['cc_number'], 0, 4) . str_repeat('x', (strlen($order->info['cc_number']) - 8)) . substr($order->info['cc_number'], -4); ?> Change to: <?php if (tep_not_null($order->info['cc_number'])) { $this->cc_card_number_less_middle_digits = substr($order->info['cc_number'], 0, 4) . str_repeat('x', (strlen($order->info['cc_number']) - 4)); ?>
  16. pleasureidea

    Fancier Invoice & Packingslip v1.0

    I am sory. I am not so good at PHP. Could you please change this code to have it like 1111 XXXX XXXX XXXX. Thank you very much for your help.
  17. pleasureidea

    Fancier Invoice & Packingslip v1.0

    Super contribution. Thank you. I have one question so far. When my customer receives invoice I would like to see him only first four numbers of his credit card, not first four and last four. 1111 XXXX XXXX 1111 <--- now 1111 XXXX XXXX XXXX <---- need Help me please on this.
  18. pleasureidea

    Links Manager For OSC v0.20 released

    I think the redirect link does not take the url_id. As I think when I point to the url to be redirected, the line at the bottom of the browser must show http://www.mysite.com/redirect.php/action/...---------url_id should be here. But it shows only http://www.mysite.com/redirect.php/action/links/goto Thank you for your help.
  19. pleasureidea

    Links Manager For OSC v0.20 released

    OK. When I change it to False, it redirects to the about:blank page. Thank you
  20. pleasureidea

    Links Manager For OSC v0.20 released

    Thanks for the answer. I got all this seted up. It seems everything was right, but still no result. :(( Click Count True Spider Friendly Links True Links Image Width 120 Links Image Height 60 Display Link Image 1 Display Link URL 4 Display Link Title 2 Display Link Description 3 Display Link Click Count 5 Link Title Minimum Length 2 Link URL Minimum Length 10 Link Description Minimum Length 10 Link Contact Name Minimum Length 2 Links Check Phrase www.mysite.com
  21. pleasureidea

    Links Manager For OSC v0.20 released

    It displays right link, but wen I click on it it redirects me to my home page and not to the url shown Thank you
  22. pleasureidea

    Links Manager For OSC v0.20 released

    Now I have restored my data base and seems it's working fine exept the problem wtih redirect. Redirect bieng made to my site and not to the needed. Checked triple redirect.php. links_url in data base has a right content, but still redirecting to my site.
  23. pleasureidea

    Links Manager For OSC v0.20 released

    I installed it, than I added a few links. After that I figured out that links actually do not go by the right direction. I decided to replace existing file includes/modules/link_listing.php with the same, but a vertical version of listing, which is included in install package. And finally I got this error, than replace this file with the original one, but seems the base is crashed somehow Thank you for your Answer.
  24. pleasureidea

    Links Manager For OSC v0.20 released

    When I first install this wonderful contribution I was getting links redirect to my site and not to another url. Then I was trying to replace existing includes/modules/link_listing.php with vertical version and I got this error: Warning: Division by zero in /home/my_site/public_html/catalog/includes/classes/split_page_results.php on line 59 1064 - 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 'MAX_LINKS_DISPLAY' at line 1 select l.links_image_url, ld.links_title, ld.links_description, l.links_url, l.links_clicked, l.links_id from links_description ld, links l, links_to_link_categories l2lc where l.links_status = '2' and l.links_id = l2lc.links_id and ld.links_id = l2lc.links_id and ld.language_id = '1' and l2lc.link_categories_id = '1' order by ld.links_title limit -0, MAX_LINKS_DISPLAY Please help me with these questions.
×