matching product cross-sell with easy populate

[nahi_sonu]

Hi,
i have been using these contributions

Matching Products Cross-Sell: osCommerce Community Add-Ons
Support thread: MATCHING PRODUCTS CROSS-SELL - osCommerce Community Support Forums

EasyPopulate: osCommerce Community Add-Ons
Support thread: Easy Populate & Products Attributes - osCommerce Community Support Forums


the matching product cross-sell create SKUs for all the product but when i export the CSV file from easypopulate it does NOT have sku field in it.. is there any way to add it.
so whenever we use exporting thru easypopulate it automatically gets product_ids from cross-sell contr and adds it to the export file??
i really need this asap.
please help me here guys.. im not too good with coding.. but i pick things easily.
thanks in advance.
bye

[pgmarshall]

Hi nahi_sonu,

Your first mod stores the new SKUs in the products table ...

So if you read the easypopulate.php code there are instructions in there to explain how to add new fields to your csv files. Look around line 250 ...

// ** 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' );

So you need to find the line 300

$custom_fields[TABLE_PRODUCTS] = array(); // this line is used if you have no custom fields to import/export

and change it to

$custom_fields[TABLE_PRODUCTS] = array( 'products_matching' => 'Matching_SKUs' );

It is always worth checking in the code for help ...

Hope this works for you - REMEMBER TO BACKUP BEFORE CHANGING ANYTHING.

Regards,

[nahi_sonu]

Hi,
thanks for the reply.. right after posting this thread i was testing few settings in easy populate and was able to get it working..
it was to change the

// $custom_fields[TABLE_PRODUCTS] = array( 'products_upc' => 'UPC' );

to

$custom_fields[TABLE_PRODUCTS] = array( 'products_id' => 'SKU' );


tc
bbye

[pgmarshall]

nahi_sonu,

I think you may need to use

products_matching not products_id

otherwise you will just get the products_id not the ones you have linked to using the mod - might be wrong since I do not use this mod.

Glad you got it working,

Regards,

[nahi_sonu]

hey pgmarshall,
the solution i mentioned above worked. as the contribution for cross sell uses products_id not products_matching.
so

// $custom_fields[TABLE_PRODUCTS] = array( 'products_upc' => 'UPC' );

to

$custom_fields[TABLE_PRODUCTS] = array( 'products_id' => 'SKU' );

works like a charm.

Resolved thread needs to be closed