[osCmax v2.5x] Modifying Easypopulate to work with MSRP

[RichardLOZ]

Hi again,

After using easypopulate on my existing live oscommerce store it is something that I would struggle to do without now as far as updating product quantities is concerned.

Love the features in 2.5, however the easypopulate mod bundled within it does not work with the MSRP module. I have played with the code a little and did manage to extract the additional MSRP field, however no matter which way I went could not get it to populate back to the database and just kept receiving errors.

Any suggestions or pointers as to the best way to go with this, or if anyone else has already done this, the help would be most appreciated.

Cheers

Richard

[pgmarshall]

The instructions for adding fields etc. into easypopulate are actually in the source code! If you read through it you should find some comments. From memory you can only add fields in the products and products_description tables.

Regards,

[RichardLOZ]

Ii am sure that I followed the instructions, but I am still getting the following error after upload.

File uploaded.
Temporary filename: /tmp/phpf7sNw2
User filename: stock_test.csv
Size: 70983
| TMAMB | Apple Mapl | Individ | | tmamb.jpg | 2.95 | 2.5 | | | | | | | | | | 26 | 0.05 | | 1/10/2011 | | Wax Melts | | 1 oz Tart | | | | | | | | | | | | Non Taxabl | Active Updated
| TMAJP | Applejack | Individ | | tmajp.jpg | 2.95 | 2.5 | | 1.3 | 1 | 1.8 | 2 | | | | | 38 | 0.05 | | 1/11/2011 | | Wax Melts | | 1 oz Tart | | | | | | | | | | | | Non Taxabl | Active Updated
1136 - Column count doesn't match value count at row 1

INSERT INTO products_groups VALUES ( 1, 1.3, 2 )

[TEP STOP]

This is the problem that I am having.

Cheers

Richard

[pgmarshall]

You have a mismatch between the number of bits of data you are inserting and the number of columns in the table. This is definitely a setup issue.

Can you post the section out of easypopulate.php where you inserted the extra fields.

Regards,

[RichardLOZ]

Here it is below. Maybe I am missing something, but as far as I can read from the instructions this should be all I have to do?

// 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( 'products_msrp' => 'MSRP' ); // 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.

I have also set the below...

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

Thanks

Richard

[pgmarshall]

$custom_fields[TABLE_PRODUCTS] = array( 'products_msrp' => 'MSRP' );

Should work - I will test later to see if I can get anywhere with this.

Regards,

[ridexbuilder]

Try:

// Extra Fields Contribution
define ('EP_EXTRA_FIELDS_SUPPORT', false); // default is false

It confused me, as there are EPF and PEF contributions.
Worth a try?

[RichardLOZ]

I have tried with both settings, true and false and still receive the same error when it tries to insert back into the DB

Richard

[mraeryceos]

What I understand from the instructions, is that you have to create the new fields, and THEN add those new fields to the EasyPopulate system. EasyPopulate does not add fields. You have to instruct EasyPopulate of the existence of new fields.

This is not an authoritative answer, just a hypothesis.

edit: Easy Populate

[RichardLOZ]

Hey all,

Just wondering if anyone had anything else to add to this as far as what to try next?

Cheers

Richard