Easy Populate not writing to database

[muhammad_barki]

Hi,

 

I was wondering if any one can help me with this issue. I have just installed the 'Individual Product Shipping Prices - v.4.5' and have tried to integrate it with the already installed 'Easy Populate 2.76i-MS2'.

 

EP exports the file perfectly fine but when it comes to importing data, EP doesnt add the shipping prices to the database. It updates all the other details of products as normal.

 

Has any come across such issue and knows how to fix it? If not then is someone using these 2 contributes together successfully? If so, will it possible for them to upload their easypopulate.php so I can compare it with mine?

 

Thanks.

[♥geoffreywalton]

Try editing ep.php and follow the instructions in it on how to get it to update new fields that are used in "newly" installed contributions.

 

HTH

 

G

[muhammad_barki]

Try editing ep.php and follow the instructions in it on how to get it to update new fields that are used in "newly" installed contributions.

 

HTH

 

G

 

Hi,

 

Yes, I have followed the instructions for modifying EP to enable import and export of shipping prices. I have also narrowed the issue down to the UPDATE query. The EP works fine on INSERT but when it comes to updating the fields it doesnt update the shipping prices.

 

Here is my update query.

 

			        // update products table with indv shipping
                   $query = "UPDATE " . TABLE_PRODUCTS . " as p JOIN " . TABLE_PRODUCTS_SHIPPING . " ps ON p.products_id=ps.products_id
                             SET
                               p.products_price='$v_products_price', 
                               ps.products_ship_price='$v_products_ship_price', 
                               ps.products_ship_price_two='$v_products_ship_price_two', 
                               $tmp_products_image_update
                               $ep_additional_updates
                               p.products_weight='$v_products_weight', 
                               p.products_tax_class_id='$v_tax_class_id', 
                               p.products_date_available=".$v_date_avail.", 
                               p.products_date_added=".$v_date_added.",
                               p.products_last_modified='".date("Y-m-d H:i:s")."', 
                               p.products_quantity = $v_products_quantity, 
                               p.manufacturers_id = ".(!empty($v_manufacturer_id)?$v_manufacturer_id:'NULL').", 
                               p.products_status = $v_db_status
                             WHERE
                               (p.products_id = $v_products_id AND ps.products_id=$v_products_id)
                               ";
                   tep_db_query($query);
				//$v_products_id = tep_db_insert_id();