Jump to content
VJ

Easy Populate & Products Attributes

Recommended Posts

I am new to php coding, and I am learning as I go along. I am literally diving into the coding and figuring it out as I need to, so this may end up being a dumb question...

 

I am having problems simply installing Easy Populate. When it came to the step to edit /catalog/admin/includes/boxes/catalog.php, I ended up with this:

 

 

<?php

/*

$Id$

 

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 2010 osCommerce

 

Released under the GNU General Public License

*/

 

$cl_box_groups[] = array(

'heading' => BOX_HEADING_CATALOG,

'apps' => array(

array(

'code' => FILENAME_CATEGORIES,

'title' => BOX_CATALOG_CATEGORIES_PRODUCTS,

'link' => tep_href_link(FILENAME_CATEGORIES)

),

array(

'code' => FILENAME_PRODUCTS_ATTRIBUTES,

'title' => BOX_CATALOG_CATEGORIES_PRODUCTS_ATTRIBUTES, 'Easy Populate'.

'link' => tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES)

),

array(

'code' => FILENAME_MANUFACTURERS,

'title' => BOX_CATALOG_MANUFACTURERS,

'link' => tep_href_link(FILENAME_MANUFACTURERS)

),

array(

'code' => FILENAME_REVIEWS,

'title' => BOX_CATALOG_REVIEWS,

'link' => tep_href_link(FILENAME_REVIEWS)

),

array(

'code' => FILENAME_SPECIALS,

'title' => BOX_CATALOG_SPECIALS,

'link' => tep_href_link(FILENAME_SPECIALS)

),

array(

'code' => FILENAME_PRODUCTS_EXPECTED,

'title' => BOX_CATALOG_PRODUCTS_EXPECTED,

'link' => tep_href_link(FILENAME_PRODUCTS_EXPECTED)

)

)

);

?>

 

 

However, when I go into my admin panel, the first time I got a parse error expecting a t string, or something like that. I undid the edit, then went back and changed it to the above. Now whenever I click on "Product Attributes" in Admin > Catalog, it just kicks back to the main admin page. What did I manage to screw up? Lol.

Share this post


Link to post
Share on other sites

you got

array(
'code' => FILENAME_PRODUCTS_ATTRIBUTES,
'title' => BOX_CATALOG_CATEGORIES_PRODUCTS_ATTRIBUTES, 'Easy Populate'.
'link' => tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES)
),

when it should be

array(
	'code' => FILENAME_PRODUCTS_ATTRIBUTES,
	'title' => BOX_CATALOG_CATEGORIES_PRODUCTS_ATTRIBUTES,
	'link' => tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES)
  ),

if you want to include easy populate you add, directly below the last bit of code

 array(
	'code' => 'easypopulate.php',
	'title' => 'Easy Populate',
	'link' => tep_href_link('easypopulate.php')
  ),

so you would then have

array(
	'code' => FILENAME_PRODUCTS_ATTRIBUTES,
	'title' => BOX_CATALOG_CATEGORIES_PRODUCTS_ATTRIBUTES,
	'link' => tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES)
  ),
 array(
	'code' => 'easypopulate.php',
	'title' => 'Easy Populate',
	'link' => tep_href_link('easypopulate.php')
  ),

Edited by puddlec

App created for phoenix
TinyMCE editor for admin

 

Share this post


Link to post
Share on other sites

Thank you! It's now working! Yay!

 

 

STEP #3 - Add a link in the Admin Panel. Edit file "/catalog/admin/incudes/boxes/catalog.php"

 

 

Find this code (Around Line 25):

 

'' . BOX_CATALOG_CATEGORIES_PRODUCTS_ATTRIBUTES . '' .

 

Directly AFTER add this:

 

'Easy Populate' .

 

 

Those were the directions, and I KNEW that couldn't be right because nothing was linking to EP. The developer of this contrib might want to fix those directions. Lol. Newbs like me end up with idiot coding mistakes otherwise. ^_^

Share this post


Link to post
Share on other sites

Okay, I DID go through the configuration variables section, and I was wondering if there is a way to change the EP .csv format to match the configuration of the .csv feed from my dropshipper, so that I can integrate directly from their feed into my store inventory. I tried to find a way to do this with their live XML feed, but to no avail. I stumbled upon Easy Populate after checking for something compatible with .csv. I am a newb, but I am a fast learner. Is there anyone that can help me tackle this issue?

Share this post


Link to post
Share on other sites

Okay, I DID go through the configuration variables section, and I was wondering if there is a way to change the EP .csv format to match the configuration of the .csv feed from my dropshipper, so that I can integrate directly from their feed into my store inventory. I tried to find a way to do this with their live XML feed, but to no avail. I stumbled upon Easy Populate after checking for something compatible with .csv. I am a newb, but I am a fast learner. Is there anyone that can help me tackle this issue?

 

You could hack the code to work with your dropship file or write an excel macro to reorder the columns, put in the correct headers and add the EOREOR column.

 

Both of which will take some time to do.

 

Which are you better at php or excel vba?

 

HTH

 

G


Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Share this post


Link to post
Share on other sites

you got

array(
'code' => FILENAME_PRODUCTS_ATTRIBUTES,
'title' => BOX_CATALOG_CATEGORIES_PRODUCTS_ATTRIBUTES, 'Easy Populate'.
'link' => tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES)
),

when it should be

array(
	'code' => FILENAME_PRODUCTS_ATTRIBUTES,
	'title' => BOX_CATALOG_CATEGORIES_PRODUCTS_ATTRIBUTES,
	'link' => tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES)
  ),

if you want to include easy populate you add, directly below the last bit of code

 array(
	'code' => 'easypopulate.php',
	'title' => 'Easy Populate',
	'link' => tep_href_link('easypopulate.php')
  ),

so you would then have

array(
	'code' => FILENAME_PRODUCTS_ATTRIBUTES,
	'title' => BOX_CATALOG_CATEGORIES_PRODUCTS_ATTRIBUTES,
	'link' => tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES)
  ),
 array(
	'code' => 'easypopulate.php',
	'title' => 'Easy Populate',
	'link' => tep_href_link('easypopulate.php')
  ),

 

 

I was having the exact same issue as the posting before this qoute. With little to no programming experiance, I am self teaching myself as I go. I want to say thanks, your post repaired my issue. I am not tech savvy enough yet to know why it is working now, but I do know it is working. Thanks again

Share this post


Link to post
Share on other sites

Hi everyone.

 

I'm having an error and trying to solve it, but with no success,

All my prices are being rounded and uploading do no respect decimals.

 

Example:

Product price (including tax 21%) = 62.24€

Product on shop (sowing tax:true) = 62.00€

(Those are not exact prices, just an example of EP uploading behaviour)

 

Does anybody knows how can I fix that?

 

I've found a "round" function at easypopulate.php at lines: 973, 2638 and 2671, but I don't know how change them (if I must do so) to avoid them (or one of them) rounding my prices.

 

I also found some information about a new version of EP that fixes that issue, but I can't find a newer version than mine at http://addons.oscommerce.com/info/500 for my osCommerce version.

 

I must say I'm so much newbie on osCommerce and their contributions as well as on PHP code, so I must sorry in advance if anything I said was a stupid thing.

 

 

I'm running an osCommerce 2.3.1

 

My settings:

 

Settings & Info

EP vers: 2.77a-2.3.1

osCommerce Online Merchant v2.3

OS: Array

HTTP:

DB:

PHP: Array (Zend: )

 

Temp Directory:

/var/www/wetsensations/temp/

Temp Dir is Writable

Magic Quotes is: off

register_globals is: off

Split files on: 300 records

Model Num Size: 5

Price with tax: true

Calc Precision: 2

Replace quotes: false

Field seperator: tilde

Excel safe output: true

Preserve tab/cr/lf: false

Category depth: 2

Enable attributes: false

SEF Froogle URLS: false

 

Other Support:

MVS Support: false

Additional Images: false

More Pics: false

UltraPics Pics: false

Unlimited Images: false

HTC: false

SPPC: false

Extra Fields: true

PDF Upload: false

Quick Backup Enabled: true

 

 

My easypopulate.php file seems too long to paste in here so I'll paste the settings part of it and the blocks I thinks are involved on that issue. The rest of the file is the same as default. If you need more info, please tell me. I don't know if any other part is important or involved on that.

 

Easypopulate.php settings:

 

// Current EP Version

define ('EP_CURRENT_VERSION', '2.77a-2.3.1');

 

require('includes/application_top.php');

require_once('includes/database_tables.php');

require('easypopulate_functions.php');

 

$system = tep_get_system_information();

 

//

//*******************************

//*******************************

// C O N F I G U R A T I O N

// V A R I A B L E S

//*******************************

//*******************************

 

 

//////////////////////////////////////////////////////

// *** Show all these settings on EP main page ***

// use this to debug your settings. Copy the settings

// to your post on the forum if you need help.

//////////////////////////////////////////////////////

define ('EP_SHOW_EP_SETTINGS', true); // default is: false

 

 

// **** Temp directory ****

/* ////////////////////////////////////////////////////////////////////////

//

// *IF* you changed your directory structure from stock and do not

// have /catalog/temp/, then you'll need to change this accordingly.

//

// *IF* your shop is in the default /catalog/ installation directory

// on your website, skip this Temp Directory settings info.

//

///////////////////////////////////////////////////////////////////////////

 

CREATING THE TEMP DIRECTORY

 

If your shop is in the root of your public site ( /home/myaccount/public_html/index.php ),

you should create a folder called temp from the root of your web space so that the

full path looks like this: /home/myaccount/public_html/temp/

 

Then you must set the permissions to 777. If you don't know how, ask your host.

 

 

THE DIR_FS_DOCUMENT_ROOT SETTING

 

DIR_FS_DOCUMENT_ROOT is set in your /catalog/admin/includes/configure.php

You should look at the setting DIR_FS_DOCUMENT_ROOT setting.

if it looks like this (recommended, but doesn't always work):

 

define ('DIR_FS_DOCUMENT_ROOT', $DOCUMENT_ROOT);

 

then leave it alone. If it looks like this:

 

define ('DIR_FS_DOCUMENT_ROOT', '/home/myaccount/public_html');

 

ask your host if the "/home/myaccount/public_html" portion points to your public

web space and is correct. Whether you add the trailing slash on the

path or not doesn't matter to this contrib, as long as you make the

right choice on the following setting. The best thing is to leave it

alone as long as your host can confirm it is correct and everything else

is working fine. Having said that, NO trailing slash is technically correct.

 

 

 

THE DIR_WS_CATALOG & DIR_FS_CATALOG SETTINGS

 

DIR_WS_CATALOG & DIR_FS_CATALOG are set in your /catalog/admin/includes/configure.php

They may look like this if your shop is in the root of your web space.

If you have something different, don't just change it to this.

There is probably a good reason. I'm providing this as a reference

to you-all. The DIR_FS_DOCUMENT_ROOT, the DIR_WS_CATALOG, and the

DIR_FS_CATALOG settings all combine to create the temp location below.

 

define('DIR_WS_CATALOG', '/');

define('DIR_FS_CATALOG', DIR_FS_DOCUMENT_ROOT . DIR_WS_CATALOG);

 

 

 

THIS EP_TEMP_DIRECTORY SETTING

 

Next, the following setting should set so that the DIR_FS_CATALOG setting

plus this following setting makes a correct full path to your temporary

location, like this: /home/myaccount/public_html/temp/

 

if /home/myaccount/public_html/temp/ is the correct full path to your temp

location, then:

 

define ('EP_TEMP_DIRECTORY', DIR_FS_CATALOG . 'temp/');

 

is the correct setting here. Wow, I really hope this stops the forum traffic about this !!

 

////////////////////////////////////////////////////////////////////////// */

// **** Temp directory ****

define ('EP_TEMP_DIRECTORY', DIR_FS_CATALOG . 'temp/');

 

 

//**** File Splitting Configuration ****

// we attempt to set the timeout limit longer for this script to avoid having to split the files

// NOTE: If your server is running in safe mode, this setting cannot override the timeout set in php.ini

// uncomment this if you are not on a safe mode server and you are getting timeouts

// set_time_limit(330);

 

// if you are splitting files, this will set the maximum number of records to put in each file.

// if you set your php.ini to a long time, you can make this number bigger

define ('EP_SPLIT_MAX_RECORDS', 300); // default, seems to work for most people. Reduce if you hit timeouts

//define ('EP_SPLIT_MAX_RECORDS', 4); // for testing

 

 

//**** Image Defaulting ****

// set them to your own default "We don't have any picture" gif

//define ('EP_DEFAULT_IMAGE_MANUFACTURER', 'no_image_manufacturer.gif');

//define ('EP_DEFAULT_IMAGE_PRODUCT', 'no_image_product.gif');

//define ('EP_DEFAULT_IMAGE_CATEGORY', 'no_image_category.gif');

 

// or let them get set to nothing

define ('EP_DEFAULT_IMAGE_MANUFACTURER', '');

define ('EP_DEFAULT_IMAGE_PRODUCT', '');

define ('EP_DEFAULT_IMAGE_CATEGORY', '');

 

 

//**** Status Field Setting ****

// Set the v_status field to "Inactive" if you want the status=0 in the system

define ('EP_TEXT_ACTIVE', 'Active');

define ('EP_TEXT_INACTIVE', 'Inactive');

 

// Set the v_status field to "Delete" if you want to remove the item from the system

define ('EP_DELETE_IT', 'Delete');

 

 

// If zero_qty_inactive is true, then items with zero qty will automatically be inactive in the store.

define ('EP_INACTIVATE_ZERO_QUANTITIES', false); // default is false

 

 

//**** Size of products_model in products table ****

// set this to the size of your model number field in the db. We check to make

// sure all models are no longer than this value. this prevents the database from

// getting fubared. Just making this number bigger won't help your database! They must match!

// If you increase the Model Number size, you must increase the size of the field

// in the database. Use a SQL tool like phpMyAdmin (see your host) and change the

// "products_model" field of the "products" table in your osCommerce Database.

define ('EP_MODEL_NUMBER_SIZE', 5); // default is 12

 

 

//**** Price includes tax? ****

// Set the EP_PRICE_WITH_TAX to

// false if you want the price that is exported to be the same value as stored in the database (no tax added).

// true if you want the tax to be added to the export price and subtracted from the import price.

define ('EP_PRICE_WITH_TAX', false ); // default is false

 

 

//**** Price calculation precision ****

// NOTE: when entering into the database all prices will be converted to 4 decimal places.

define ('EP_PRECISION', 2); // default is 2

 

 

// **** Quote -> Escape character conversion ****

// If you have extensive html in your descriptions and it's getting mangled on upload, turn this off

// set to true = replace quotes with escape characters

// set to false = no quote replacement

define ('EP_REPLACE_QUOTES', false); // default is false

 

 

// **** 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 = '~'; // tilde // 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', 2); // 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', false); // 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

// ******************************************************************

 

 

 

// ****************************************

// Froogle configuration variables

// Here are some links regarding Bulk uploads

// http://www.google.com/base/attributes.html

// http://www.google.com/base/help/custom-attributes.html

// ****************************************

 

// **** Froogle product info page path ****

// We can't use the tep functions to create the link, because the links will point to the

// admin, since that's where we're at. So put the entire path to your product_info.php page here

define ('EP_FROOGLE_PRODUCT_INFO_PATH', HTTP_CATALOG_SERVER . DIR_WS_CATALOG . "product_info.php");

 

// **** Froogle product image path ****

// Set this to the path to your images directory

define ('EP_FROOGLE_IMAGE_PATH', HTTP_CATALOG_SERVER . DIR_WS_CATALOG_IMAGES);

 

// **** Froogle - search engine friendly setting

// if your store has SEARCH ENGINE FRIENDLY URLS set, then turn this to true

// I did it this way because I'm having trouble with the code seeing the constants

// that are defined in other places.

define ('EP_FROOGLE_SEF_URLS', false); // default is false

 

// **** Froogle Currency Setting

define ('EP_FROOGLE_CURRENCY', 'USD'); // default is 'USD'

 

// ****************************************

// End: Froogle configuration variables

//

 

 

// ***********************************

// *** Other Contributions Support ***

// ***********************************

 

// More Pics 6 v1.3

define ('EP_MORE_PICS_6_SUPPORT', false); // default is false

 

// Header Tags Controller Support v2.0

define ('EP_HTC_SUPPORT', false); // default is false

 

// Separate Pricing Per Customer (SPPC) v4.1.x

define ('EP_SPPC_SUPPORT', false); // default is false

 

// X-Sell 2.6 Support

define ('EP_XSELL_SUPPORT', false); // default is false

 

// Additional Images v2.1.1

define ('EP_ADDITIONAL_IMAGES', false); // default is false

define ('EP_ADDITIONAL_IMAGES_MAX', 6); // default is 6, maximum number of columns

 

// Unlimited Images

define ('EP_UNLIMITED_IMAGES', false); // default is false

 

// Multi Vendor System (MVS) 1.2 support

define ('EP_MVS_SUPPORT', false); // default is false

 

// Extra Fields Contribution

define ('EP_EXTRA_FIELDS_SUPPORT', true); // default is false

 

// UltraPics 2.05 LightBox Contrib (***FUNCTIONAL***)

define ('EP_ULTRPICS_SUPPORT', false); // default is false

 

// PDF File Upload and Display v2.01 (***FUNCTIONAL***)

define ('EP_PDF_UPLOAD_SUPPORT', false); // default is false

 

// Enable Quick Backup Button for oscommerce backup.php

define ('EP_QUICK_BACKUP', true); // default is true

 

//*******************************

//*******************************

// E N D

// C O N F I G U R A T I O N

// V A R I A B L E S

//*******************************

//*******************************

 

 

1st Block of rounding behaviour (as I think). Line 973:

 

 

//elari -

//We check the value of tax class and title instead of the id

//Then we add the tax to price if EP_PRICE_WITH_TAX is set to true

$row_tax_multiplier = tep_get_tax_class_rate($row['v_tax_class_id']);

$row['v_tax_class_title'] = tep_get_tax_class_title($row['v_tax_class_id']);

$row['v_products_price'] = $row['v_products_price'] +

(EP_PRICE_WITH_TAX == true ? round( ($row['v_products_price'] * $row_tax_multiplier / 100), EP_PRECISION) : 2);

 

 

2nd block of roundinf behaviour. Line 2638:

 

 

//elari -

//We check the value of tax class and title instead of the id

//Then we add the tax to price if EP_PRICE_WITH_TAX is set to true

$row_tax_multiplier = tep_get_tax_class_rate($row['v_tax_class_id']);

$row['v_tax_class_title'] = tep_get_tax_class_title($row['v_tax_class_id']);

if (EP_PRICE_WITH_TAX == true){

$row['v_products_price'] = $row['v_products_price'] + round(($row['v_products_price'] * $row_tax_multiplier / 100), EP_PRECISION);

 

 

3rd block. Line 2671:

 

 

//And we recalculate price without the included tax...

//Since it seems display is made before, the displayed price will still include tax

//This is same problem for the tax_clas_id that display tax_class_title

if (EP_PRICE_WITH_TAX == true){

$v_products_price = round( $v_products_price / (1 + ($row_tax_multiplier * .01)), EP_PRECISION);

 

 

 

Really thank you in advance for any help. I really need that working fine.


------------------------------------------------

Wet Sensations Shop owner.

http://www.wetsensations.es

Share this post


Link to post
Share on other sites

Running osc 2.3.3

 

Hello all, I figured this would be the best place to post my solution to combine both of the these excellent Add Ons. Easy Populate and the Year Make Model (YMM) contributions are both really great. We have a auto parts store that sells customs body kits so our product db goes way over 100,000 products.

 

Here's my solution:

 

In the easypopulate.php file there are instructions to add custom fields into either the products or products_description tables. I added these columns into the products_description page:

 

products_car_make

products_car_model

products_car_part

products_car_year_bof

products_car_year_eof

 

Now these will appear in your excel file. Be sure to add these columns into the products_description table in phpmyadmin as well.

 

Now, the latest version of ymmp has a table called products_ymm, you'll notice the same column headers there in phpmyadmin.

 

Well now we want to move that data over to the ymm table so it will show up in our drop downs. To do this, either export then import the data using excel files. or use this statement:

 

 

INSERT INTO `products_ymm`(`products_id`, `products_car_make`, `products_car_model`, `products_car_part`, `products_car_year_bof`, `products_car_year_eof`)

SELECT `products_id`, `products_car_make`, `products_car_model`, `products_car_part`, `products_car_year_bof`, `products_car_year_eof`

FROM `products_description`

 

There are a few steps involved, this is my first instructional post, so please feel free to ask and I will provide more clarity on what I did. Also, if anyone has a better way, please advise!

Share this post


Link to post
Share on other sites

I exported the csv wit easy populate, added products COPYING EXACTLY the format of the products already in the csv. Uploaded the csv with ep & got NO ERRORS AT ALL. But.........the descriptions in my products are cut off with just the first 10 or words left.

The csv had just 34 products. I also tried splitting into just 5 products, no luck. You can see what I mean about cut descriptions here:

http://classycateringcreations.com/marketplace?slug=product_info.php&products_id=59

 

Can anyone tell me why it is doing this or how to fix it???

Share this post


Link to post
Share on other sites

Looks good to me now, I would think it was to do with using special charachters such as single quotes. These need to be escaped.

 

A google search will how you the solution.

 

Cheers

 

G


Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Share this post


Link to post
Share on other sites

I have problem with easy populate when i download special price(problem is thay doesnt show at all), when this special price have expire date included. When I delete expire date let say with phpmyadmin I can download special price. Is eanyobody have the same issue, please let me now. I use easy populate 2.8.231 oscommerce 2.3.3, ubuntu and edit .csv file with libre office...

Share this post


Link to post
Share on other sites

Looks good to me now, I would think it was to do with using special charachters such as single quotes. These need to be escaped.

 

A google search will how you the solution.

 

Cheers

 

G

 

 

Hello and thanks for help Mr. Walton

 

I'd find the issue was the interface chair-keyboard. Yes, me Y_Y

 

I was using an wrong character to delimite float numbers, so the database didn't recognize them and converted my data.

 

This issue is solved and EP is working fine for me now.

 

Thanks a lot.

Edited by McKyavelik

------------------------------------------------

Wet Sensations Shop owner.

http://www.wetsensations.es

Share this post


Link to post
Share on other sites

I hate to post this but i have been looking around for about an hour now and i cant find Easy Populate for 2.3.3. I have downloaded EP_v2_77a_for_2.3 but it doesn’t work for me. I see nothing in catalog/admin for Easy Populate. Can someone please point me in the right direction? Thanks

Share this post


Link to post
Share on other sites

I hate to post this but i have been looking around for about an hour now and i cant find Easy Populate for 2.3.3. I have downloaded EP_v2_77a_for_2.3 but it doesn’t work for me. I see nothing in catalog/admin for Easy Populate. Can someone please point me in the right direction? Thanks

 

This reads as if you have not added the extra code into /includes/boxes/catalog

 

Try rereading the installation instructions, if there is nothing there try the installation instructions from earlier versions.

 

HTH

 

G

Edited by geoffreywalton

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Share this post


Link to post
Share on other sites

I started a new database for a new domain name, and was trying to upload all of the products at once using product model, name, description, price and categories name. This is a completely fresh install of oscommerce.

 

When I use easy populate to import the file, it uploads only a few of the products in to the categories... the rest of the products are placed out of folders, and the other category names are not created. Also, I have some duplicate titles that are supposed to go in to separate folders, however, due to the files not going in to folders like they're supposed to the duplicate titles are not made; one title is made and then instead of creating the duplicate title it just "updates" the one that it created first.

 

If someone could help me out with this situation I would greatly appreciate it. Thank you.

Edited by JustinS

Share this post


Link to post
Share on other sites

Hello,

 

I'm a total NOB in this database stuff but I want to export my inventory into a .cvs sheet so I can upload to another website.

 

listing_id artist title label catno format release_id status price listed comments media_condition sleeve_condition accept_offer external_id weight format_quantity flat_shipping

 

But I don't understand how to do this, can anybody help?

 

Cheers


-Peder Beckman-

Kool Kat Jazz Records

Share this post


Link to post
Share on other sites

Hello all,

 

Been playing with my site for a while now and have been adding items to my store manually.

 

I get excel or comma delimited files of catalogues from my suppliers (product distributors)

 

If I was to reformat these files, so that the info fell under renamed headers that fit OSC .. then I could use easy Populate to import these catalogues and save me HUNDREDS of hours of entry??

 

My only thing missing for each item would be an image.

 

Does this sound do-able?

 

thanks

James

Share this post


Link to post
Share on other sites

I have probably missed the answer amongst the 439+ pages...lol

 

I am using osCommerce 2.2-MS2 & EP 2.77a

 

I have managed to download and edit a CSV but it wouldnt load, so due to 3000+ products I tried using the the upload and split.

 

I have used the default 300 as well as 200, 100 and 50 for the number of records per split.

 

However when i upload the file to be split it does the old working thing and then just reverts back to the Easy Populate screen. There are no error messages and as you can guess no split files to insert.

 

My EP settings are:

Settings & Info

 

EP vers: 2.77a

osCommerce 2.2-MS2

OS:

HTTP: Apache/2.2.22 (Unix) mod_ssl/2.2.22 OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635

DB: MySQL 5.0.96-community

PHP: 5.2.17 (Zend: 2.2.0)

 

Temp Directory:

/home/r*******/public_html/temp/

Temp Dir is Writable

Magic Quotes is: off

register_globals is: off

Split files on: 300 records

Model Num Size: 12

Price with tax: false

Calc Precision: 2

Replace quotes: false

Field seperator: comma

Excel safe output: true

Preserve tab/cr/lf: false

Category depth: 7

Enable attributes: true

SEF Froogle URLS: false

 

Other Support:

MVS Support: false

Additional Images: false

More Pics: false

UltraPics Pics: false

Unlimited Images: false

HTC: false

SPPC: false

Extra Fields: false

PDF Upload: false

Quick Backup Enabled: true

 

Any Idea's?

 

As stated i have searched via Google and this thread but there is a lot so i have either missed it or sommat


Complete Newbie On The Learn - Not A Programmer

But Learning As I Go

Share this post


Link to post
Share on other sites

I have probably missed the answer amongst the 439+ pages...lol

 

I am using osCommerce 2.2-MS2 & EP 2.77a

 

I have managed to download and edit a CSV but it wouldnt load, so due to 3000+ products I tried using the the upload and split.

 

I have used the default 300 as well as 200, 100 and 50 for the number of records per split.

 

However when i upload the file to be split it does the old working thing and then just reverts back to the Easy Populate screen. There are no error messages and as you can guess no split files to insert.

 

My EP settings are:

Settings & Info

 

EP vers: 2.77a

osCommerce 2.2-MS2

OS:

HTTP: Apache/2.2.22 (Unix) mod_ssl/2.2.22 OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635

DB: MySQL 5.0.96-community

PHP: 5.2.17 (Zend: 2.2.0)

 

Temp Directory:

/home/r*******/public_html/temp/

Temp Dir is Writable

Magic Quotes is: off

register_globals is: off

Split files on: 300 records

Model Num Size: 12

Price with tax: false

Calc Precision: 2

Replace quotes: false

Field seperator: comma

Excel safe output: true

Preserve tab/cr/lf: false

Category depth: 7

Enable attributes: true

SEF Froogle URLS: false

 

Other Support:

MVS Support: false

Additional Images: false

More Pics: false

UltraPics Pics: false

Unlimited Images: false

HTC: false

SPPC: false

Extra Fields: false

PDF Upload: false

Quick Backup Enabled: true

 

Any Idea's?

 

As stated i have searched via Google and this thread but there is a lot so i have either missed it or sommat

 

ANYONE?


Complete Newbie On The Learn - Not A Programmer

But Learning As I Go

Share this post


Link to post
Share on other sites

Hello,

 

I'm a total NOB in this database stuff but I want to export my inventory into a .cvs sheet so I can upload to another website.

 

listing_id artist title label catno format release_id status price listed comments media_condition sleeve_condition accept_offer external_id weight format_quantity flat_shipping

 

But I don't understand how to do this, can anybody help?

 

Cheers

 

If these are fields in your current products table you could just export thr products table using phpmyadmin.

 

HTH

 

G

 

@@pederb

Edited by geoffreywalton

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Share this post


Link to post
Share on other sites

Hello all,

 

Been playing with my site for a while now and have been adding items to my store manually.

 

I get excel or comma delimited files of catalogues from my suppliers (product distributors)

 

If I was to reformat these files, so that the info fell under renamed headers that fit OSC .. then I could use easy Populate to import these catalogues and save me HUNDREDS of hours of entry??

 

My only thing missing for each item would be an image.

 

Does this sound do-able?

 

thanks

James

 

James

 

you can import the image file name ujsing EP but have to ftp the actual file to the correct place using an ftp client such as filezilla to the images directory on your web server.

 

HTH

 

G

 

@@James Schofield


Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Share this post


Link to post
Share on other sites

ANYONE?

 

Try splitting off the first 10 lines of the file manually into another file and upload that.

 

It sound to me that, despite what is shown on the screen, you do not have access rights to create files in the temp directory.

 

HTH

 

G

 

@toyzonline

Edited by geoffreywalton

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Share this post


Link to post
Share on other sites

Try splitting off the first 10 lines of the file manually into another file and upload that.

 

It sound to me that, despite what is shown on the screen, you do not have access rights to create files in the temp directory.

 

HTH

 

G

 

@toyzonline

 

HI G

 

I have tried to do the 10 lines and this worked and it placed the test file in the temp directory.

 

Ricardo

Edited by toyzonline

Complete Newbie On The Learn - Not A Programmer

But Learning As I Go

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×