EasyPopulate 4.0 Support Thread

[mc12345678]

What is the significance of using a zero instead of a +? The ZC standard price_prefix of those two is, '+, -, or blank' does a value (number not a character) of zero mean something unique in your store?, if so, then may have to look up which line(s) to change to force the conversion to use a value instead of a string...

[solo_400]

Hi, is there a way to import products and setting in csv file Product Qty Min/Unit Mix = Yes ?

thx

[mc12345678]

Hi, is there a way to import products and setting in csv file Product Qty Min/Unit Mix = Yes ?

thx

Yes, by including the field header of: v_products_quantity_mixed
for each value that is to have Product Qty Min/Unit Mix set to Yes, use the numerical value 1 in that row.

A value of 0 will set it to No.

If you would like that field to be included more often, ie on each export as applicable, then in the configuration for Easy Populate, add the following into the custom field section:
products_quantity_mixed

Then on export, the current value will be included, and then on import it will also be incorporated.

[solo_400]

I have placed column v_products_quantity_mixed using value 1 after column v_products_quantity but after the import product has Product Qty Min/Unit Mix = No

[mc12345678]

I have placed column v_products_quantity_mixed using value 1 after column v_products_quantity but after the import product has Product Qty Min/Unit Mix = No

Maybe should have also asked: ZC version? Try a product with a value of 0? Also was the user defined field populated as described above. If not mistaken in one ZC version change they swapped the values. I verified in zc 1.5.1 that 1 was was yes, and 0 was no. It may be reversed in an older version.

[solo_400]

What a crack ... I don't like when I can't understand .

-My version is 1.5.0
-I tried with 0 and 1 and no change
- I got mysql under query logging
-When I import ( in this case by updating the already imported product.. result don't change when product is new ) I can see the sql log:

UPDATE products SET
products_price = '135.9',products_image = 'xxxx/xxxxxxx.pg',
products_weight = '0',
products_discount_type = '0',
products_discount_type_from = '0',
product_is_call = '0',
products_sort_order = '0',
products_quantity_order_min = '0',
products_quantity_order_units = '0',
products_priced_by_attribute = '0',
product_is_always_free_shipping = '0',
products_tax_class_id = '1',
products_date_available = NULL,
products_date_added = '2015-01-24 00:00:00',
products_last_modified = CURRENT_TIMESTAMP,
products_quantity = '1',
manufacturers_id = '56',
products_status = '1',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = '0' WHERE (products_id = '8917')

As we can see the column products_quantity_mixed is not present on update or insert ( I have also did a general search for this field in all module's files ) action. That's why is being imported with default 0 column value.

Am I doing something wrong here ?

[mc12345678]

Have you added the field into the configuration section of Easy Populate?

Admin panel->configuration->Easy Populate 4
Towards the bottom of the selections is a menu option similar to custom fields.
Click on it and a box should appear on the right side, if it has an edit button, select the edit button, otherwise enter: products_quantity_mixed

If there is already something there, then add a comma and then products_quantity_mixed without spaces....

If anything, that right now is what has been missed or not identified as being done.

[mc12345678]

And to provide understanding. The default install does not include the field products_quantity_mixed, so yes will default to whatever the database has as a default. In this case a zero. That said, eP4 was brilliantly written (not by me) to allow adding other fields that are in the products table to be appended.... This happens through the custom fields data entered in the admin.... If you search the code for custom you can find how/where it is used....

[solo_400]

You totally zenned me :-) Thank you, it worked.

Now I have a more serious problem:

How can I tell EP4, after each product import to generate ceon_uri_mappings links ?

my_new_product
my_new_product/reviews
my_new_product/review
my_new_product/write-a-review

Please don't tell me after new 1000 products imported one must manually go on every product and press update in order to generate ceon uri mappings links.

thx

[mc12345678]

You totally zenned me :-) Thank you, it worked.

Now I have a more serious problem:

How can I tell EP4, after each product import to generate ceon_uri_mappings links ?

my_new_product
my_new_product/reviews
my_new_product/review
my_new_product/write-a-review

Please don't tell me after new 1000 products imported one must manually go on every product and press update in order to generate ceon uri mappings links.

thx

Let me see if I can zennly state it. Without venturing away from this site to obtain some additional software (maybe by following a link on this post/page), it would require a manual edit/save... I think beyond that I'm not allowed to publicly discuss it much further...