Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2006
    Posts
    1
    Plugin Contributions
    0

    Default update products with data manager?

    Sorry for my english...

    I've installed zen cart in my store succesfully but I need to edit many products at the same time.
    For this, I use Data manager and import works great!. I need updated the catalog every day with information about stock and price, but I don't want to create all the products each.
    I'm trying to edit the code for Data manager, and I think that questio is in import csv information to MySql.
    I find this:
    Code:
    	if ($import_method == 'insert') {
    					$import_csv_query = "INSERT INTO " . $current_table . ( $sql_fields !== false ? " ($sql_fields)" : '') . " VALUES ";
    				}
    And try to add a "ON DUPLICATE KEY UPDATE" instruccion, but always failed!
    anybody can help me, please?

  2. #2
    Join Date
    Jan 2004
    Posts
    66,373
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: update products with data manager?

    Since all you need is stock and price, why not use Easy Populate, rather than have to customize code?
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

 

 

Similar Threads

  1. v139h Update all exisiting products with Sales Tax with SQL Statement?
    By toussi in forum Setting Up Categories, Products, Attributes
    Replies: 0
    Last Post: 18 Jun 2012, 06:22 PM
  2. Import / update products from external data source
    By prossel in forum All Other Contributions/Addons
    Replies: 2
    Last Post: 2 Sep 2008, 02:26 PM
  3. Update Data With SQLScripts Created In Excel
    By JuxiZoza in forum Setting Up Categories, Products, Attributes
    Replies: 74
    Last Post: 23 Mar 2006, 05:16 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR