Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

pozz

Pioneers
  • Posts

    6
  • Joined

  • Last visited

Everything posted by pozz

  1. 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?
  3. Hi Love this contr. But when i click on a product the logo centers itselt, its on the right othervise. And the heading of the boxes on the right and left goes center also. Why is this? *edit* found it in the FAQ :-"
×
×
  • Create New...