Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

pozz

Pioneers
  • Posts

    6
  • Joined

  • Last visited

Posts posted by pozz

  1. Have you edited the file so it is in the format required by EP?

     

    Doesn't appear so, which probably explains why it is not working.

     

    Try exporting a file as this will have the correct column headings.

     

    Then try reading the documentation that comes with the download and also open easypopulate.php because there are a shed load of parameters you can set by editing values in this file.

     

    Enjoy

     

    G

     

    Ive tried it all but i just cant get i to work.

    Can some1 please help me whit the setting in this file so that my productlist works, see first post how that looks.

     

    <?php
    // **** Field Separator ****
    // change this if you can't use the default of tabs
    // Tab is the default, comma and semicolon are commonly supported by various progs
    // Remember, if your descriptions contain this character, you will confuse EP!
    // if EP_EXCEL_SAFE_OUTPUT if false (below) you must make EP_PRESERVE_TABS_CR_LF false also.
    $ep_separator = "\t"; // tab is default
    //$ep_separator = ',';  // comma
    //$ep_separator = ';';  // semi-colon
    //$ep_separator = '~';  // tilde
    //$ep_separator = '*';  // splat
    
    
    // *** Excel safe output ***
    // this setting will supersede the previous $ep_separator setting and create a file
    // that excel will import without spanning cells from embedded commas or tabs in your products.
    // if EP_EXCEL_SAFE_OUTPUT if false (below) you must make EP_PRESERVE_TABS_CR_LF false also.
    define ('EP_EXCEL_SAFE_OUTPUT', true); // default is: true
    
    if (EP_EXCEL_SAFE_OUTPUT == true) { 
     if ($language == 'english') { 
       $ep_separator = ',';  // comma
     } elseif ($language == 'german') {
       $ep_separator = ';';  // semi-colon
     } else {
       $ep_separator = ',';  // comma  // default for all others.
     }
    }
    
    // if EP_EXCEL_SAFE_OUTPUT if true (above) there is an alternative line parsing routine
    //  provided by Maynard that will use a manual php approach.  There is a bug in some
    // PHP versions that may require you to use this routine.  This should also provide proper
    // parsing when quotes are used within a string. I suspect this should also resolve an issue
    // recently reported in which characters with a german "Umlaute" like ÄäÖöÜü at the Beginning 
    // of some text, they will disappear when importing some csv-file, reported by TurboTB.
    define ('EP_EXCEL_SAFE_OUTPUT_ALT_PARCE', false); // default is: false
    
    
    // *** Preserve Tabs, Carriage returns and Line feeds ***
    // this setting will preserve the special chars that can cause problems in 
    // a text based output. When used with EP_EXCEL_SAFE_OUTPUT, it will safely
    // preserve these elements in the export and import.
    define ('EP_PRESERVE_TABS_CR_LF', false); // default is: false
    
    
    // **** Max Category Levels ****
    // change this if you need more or fewer categories.
    // set this to the maximum depth of your categories.
    define ('EP_MAX_CATEGORIES', 7); // default is 7
    
    
    // VJ product attributes begin
    // **** Product Attributes ****
    // change this to false, if do not want to download product attributes
    define ('EP_PRODUCTS_WITH_ATTRIBUTES', true);  // default is true
    
    // change this to true, if you use QTYpro and want to set attributes stock with EP.
    define ('EP_PRODUCTS_ATTRIBUTES_STOCK', false); // default is false
    
    // change this if you want to download only selected product options (attributes).
    // If you have a lot of product options, and your output file exceeds 256 columns, 
    // which is the max. limit MS Excel is able to handle, then load-up this array with
    // attributes to skip when generating the export.
    $attribute_options_select = '';
    // $attribute_options_select = array('Size', 'Model'); // uncomment and fill with product options name you wish to download // comment this line, if you wish to download all product options
    // VJ product attributes end
    
    
    // ******************************************************************
    // BEGIN Define Custom Fields for your products database
    // ******************************************************************
    // the following line is always left as is.
    $custom_fields = array();
    //
    // The following setup will allow you to define any additional 
    // field into the "products" and "products_description" tables
    // in your shop. If you have  installed a custom contribution
    // that adds fields to these tables you may simply and easily add
    // them to the EasyPopulate system.
    //
    // ********************
    // ** products table **
    // Lets say you have added a field to your "products" table called
    // "products_upc". The header name in your import file will be
    // called "v_products_upc".  Then below you will change the line
    // that looks like this (without the comment double-slash at the beginning):
    // $custom_fields[TABLE_PRODUCTS] = array(); // this line is used if you have no custom fields to import/export
    //
    // TO:
    // $custom_fields[TABLE_PRODUCTS] = array( 'products_upc' => 'UPC' );
    //
    // If you have multiple fields this is what it would look like:
    // $custom_fields[TABLE_PRODUCTS] = array( 'products_upc' => 'UPC', 'products_restock_quantity' => 'Restock' );
    //
    // ********************************
    // ** products_description table **
    // Lets say you have added a field to your "products_description" table called
    // "products_short_description". The header name in your import file will be
    // called "v_products_short_description_1" for English, "v_products_short_description_2" for German,
    // "v_products_short_description_3" for Spanish. Other languages will vary. Be sure to use the 
    // langugage ID of the custom language you installed if it is other then the original
    // 3 installed languages of osCommerce. If you are unsure what language ID you need to
    // use, do a complete export and examine the file headers EasyPopulate produces.
    //
    // Then below you will change the line that looks like this (without the comment double-slash at the beginning):
    // $custom_fields[TABLE_PRODUCTS_DESCRIPTION] = array(); // this line is used if you have no custom fields to import/export
    //
    // TO:
    // $custom_fields[TABLE_PRODUCTS_DESCRIPTION] = array( 'products_short_description' => 'short' );
    //
    // If you have multiple fields this is what it would look like:
    // $custom_fields[TABLE_PRODUCTS_DESCRIPTION] = array( 'products_short_description' => 'short', 'products_viewed' => 'Viewed' );
    //
    // the array format is: array( 'table_field_name' => 'Familiar Name' )
    // the array key ('table_field_name') is always the exact name of the 
    // field in the table. The array value ('Familiar Name') is any text
    // name that will be used in the custom EP export download checkbox.
    //
    // I believe this will only work for text/varchar and numeric field
    // types.  If your custom field is a date/time or any other type, you
    // may need to incorporate custom code to correctly import your data.
    //
    
    $custom_fields[TABLE_PRODUCTS] = array(); // this line is used if you have no custom fields to import/export
    $custom_fields[TABLE_PRODUCTS_DESCRIPTION] = array(); // this line is used if you have no custom fields to import/export
    
    //
    // FINAL NOTE: this currently only works with the "products" & "products_description" table.
    // If it works well and I don't get a plethora of problems reported,
    // I may expand it to more tables. Feel free to make requests, but
    // as always, only as me free time allows.
    //
    // ******************************************************************
    // END Define Custom Fields for your products database
    // ******************************************************************
    

  2. Hi

     

    When I try to import my productfile in the shop I get the error

    "No products_model field in record. This line was not imported: | | "

    on all products.

     

    I have read everything and tried even more but whitout success so now I´m begging for help.

     

    The file looks like this from the supplier.

     

    Artikelnummer;Benämning;Lagersaldo;Tillverkarens Artikelnummer;Grupp;U-Grupp;A-Grupp;Pris(SEK);EAN
    2360107;Pennhållare med magnet;3;C700402;AV Inredning;AV Inredning Tillbehör;Diverse;44.00;

     

    How shall I change it to work?

×
×
  • Create New...