CRE Loaded 6.2 Standard Patch 10 - EPA import/export

saderogba · **Joined:** Tue Oct 03, 2006 12:00 am **Posts:** 257

Following the clue from this thread, I put the attribute option back in 6.2 patch 10.

Please note that line numbers are approximate.

1. Export

Applies to admin/easypopulate_export.php

1.1 Uncomment attribute option drop down in line 846

1.2 Around line 370 change

Code:

      $attribute_options_query = "select distinct products_options_id from " . TABLE_PRODUCTS_OPTIONS . " where products_options_name = '" . $value . "'";

to

Code:

       $attribute_options_query="select distinct po.products_options_id from products_options po, products_options_text pot where pot.products_options_name= '".$value."' and po.products_options_id=pot.products_options_text_id";

1.3 Around line 385 change to

Code:

       $attribute_options_query="select distinct po.products_options_id from products_options po, products_options_text pot where po.products_options_id=pot.products_options_text_id";

1.4 Around line 643

change

Code:

          $attribute_options_languages_query = "select products_options_name from " . TABLE_PRODUCTS_OPTIONS . " where products_options_id = '" . (int)$attribute_options['products_options_id'] . "' and language_id = '" . (int)$lid . "'";
         

to

Code:

$attribute_options_languages_query = "select products_options_name from " . TABLE_PRODUCTS_OPTIONS_TEXT . " where products_options_text_id = '" . (int)$attribute_options['products_options_id'] . "' and language_id = '" . (int)$lid . "'";

2. Import

Applies to admin/easypopulate_import.php

2.1 Around line 1182, change

Code:

$attribute_options_query = "select products_options_name from " . TABLE_PRODUCTS_OPTIONS . " where products_options_id = '" . (int)$$v_attribute_options_id_var . "'";

to

Code:

        $attribute_options_query = "select products_options_name from " . TABLE_PRODUCTS_OPTIONS_TEXT . " where products_options_text_id = '" . (int)$$v_attribute_options_id_var . "'";

2.2 Around line 1196, change

Code:

$attribute_options_insert_query = "insert into " . TABLE_PRODUCTS_OPTIONS . " (products_options_id, language_id, products_options_name) values ('" . (int)$$v_attribute_options_id_var . "', '" . (int)$lid . "', '" . $$v_attribute_options_name_var . "')";

to

Code:

$attribute_options_insert_query = "insert into " . TABLE_PRODUCTS_OPTIONS_TEXT . " (products_options_text_id, language_id, products_options_name) values ('" . (int)$$v_attribute_options_id_var . "', '" . (int)$lid . "', '" . $$v_attribute_options_name_var . "')";

2.3 Around line 1208, change

Code:

$attribute_options_update_lang_query = "select products_options_name from " . TABLE_PRODUCTS_OPTIONS . " where products_options_id = '" . (int)$$v_attribute_options_id_var . "' and language_id ='" . (int)$lid . "'";

to

Code:

$attribute_options_update_lang_query = "select products_options_name from " . TABLE_PRODUCTS_OPTIONS_TEXT . " where products_options_text_id = '" . (int)$$v_attribute_options_id_var . "' and language_id ='" . (int)$lid . "'";

2.4 Around line 1214, change

Code:

$attribute_options_lang_insert_query = "insert into " . TABLE_PRODUCTS_OPTIONS . " (products_options_id, language_id, products_options_name) values ('" . (int)$$v_attribute_options_id_var . "', '" . (int)$lid . "', '" . $$v_attribute_options_name_var . "')";

to

Code:

$attribute_options_lang_insert_query = "select products_options_name from " . TABLE_PRODUCTS_OPTIONS_TEXT . " where products_options_text_id = '" . (int)$$v_attribute_options_id_var . "' and language_id ='" . (int)$lid . "'";

2.5 Around line 1218, change

Code:

$attribute_options_update_query = "update " . TABLE_PRODUCTS_OPTIONS . " set products_options_name = '" . $$v_attribute_options_name_var . "' where products_options_id ='" . (int)$$v_attribute_options_id_var . "' and language_id = '" . (int)$lid . "'";

to

Code:

$attribute_options_update_query = "update " . TABLE_PRODUCTS_OPTIONS_TEXT . " set products_options_name = '" . $$v_attribute_options_name_var . "' where products_options_text_id ='" . (int)$$v_attribute_options_id_var . "' and language_id = '" . (int)$lid . "'";

3.0 epconfigure

3.1 set $products_with_attributes = true;

3.2 $attribute_options_select = array('Size', 'Model'); // uncomment and fill with product options name you wish to download use $attribute_options_select = ''; if you wish to download all product options

Please BACK UP your files before any change...

kgabest · **Joined:** Sun Apr 22, 2007 12:00 am **Posts:** 3

Thanks for sharing. This is exactly what I am looking for. I will try this this week end.

saderogba · **Joined:** Tue Oct 03, 2006 12:00 am **Posts:** 257

If you run into any problem let me know.

claire · **Joined:** Tue Mar 20, 2007 12:00 am **Posts:** 2

Hi

I've done the above, but now when i try to export easy populate I get nothing. Will the above give me the option to change attrributes in excel which will be a lot quicker than each individual product page

Thanks

Claire

saderogba · **Joined:** Tue Oct 03, 2006 12:00 am **Posts:** 257

Yes it will. I'll PM you my changes.

titooooo · **Posted:** Thu May 24, 2007 2:10 pm

Hi... i have b2b (10) iÃ‚Â´m trying to import with epa with out success, even if the sistem says that it was succesfully imported.
=)
By now I reading all the forum topics

saderogba · **Joined:** Tue Oct 03, 2006 12:00 am **Posts:** 257

What is the problem you are having?

oilsshop.com · **Posted:** Mon Dec 03, 2007 4:09 pm

Hi! can i use these changes with CRE Loaded v 6.2[12.1 (SP1)] ?
I've tried but nothing appeared.

oilsshop.com · **Posted:** Mon Dec 03, 2007 8:36 pm

people! has anybody used it with CRE Loaded v 6.2[12.1 (SP1)] ?

saderogba · **Joined:** Tue Oct 03, 2006 12:00 am **Posts:** 257

I haven't not tried on 6.2[12.1 (SP1)] but I expect it to work. I'll try it and publish my findings.

saderogba · **Joined:** Tue Oct 03, 2006 12:00 am **Posts:** 257

Yes it works fine. I just tried. PM me for a demo.

gallerygirl · **Posted:** Fri Feb 15, 2008 7:28 pm

Dude! This is PERFECT. Thank you xGazilltrillions!

(Installed with 6.2[12.1 (SP1)])

canuck · **Joined:** Sun Dec 23, 2007 10:56 pm **Posts:** 2

I am trying to apply this mod to my Standar version 6.2[12.1 (SP1)] and cannot find where in the admin/easypopulate_export.php file do I uncomment the attribute option as per these instructions:

1.1 Uncomment attribute option drop down in line 846

Can anyone help me out on this ?

masscraft · **Joined:** Thu Apr 24, 2008 3:21 pm **Posts:** 19

This is fab! Thanks!

hayesb200 · **Joined:** Wed Jul 16, 2008 3:28 am **Posts:** 6

I tried adding this and its not working...
I will pay to have this done for me.
I need asap...pls help

Loaded Commerce Community

CRE Loaded 6.2 Standard Patch 10 - EPA import/export

Who is online

Main Menu

Login

Forums Latest Activity

Top Listing

Members Online