Easypopulate problem

[bkpie]

I am baffled on this. Everytime I change prices in my customer groups (I have 3) by using the easypopulate model/price/quantity upload it changes the date of the product added to today.(the day I upload the price changes) So I keep having to go in and change the date the items were added or I have 100's of old products in New Products. Where is this being called? Any ideas on a fix. Thanks.

[ALElder]

Originally Posted by bkpie

I am baffled on this. Everytime I change prices in my customer groups (I have 3) by using the easypopulate model/price/quantity upload it changes the date of the product added to today.(the day I upload the price changes) So I keep having to go in and change the date the items were added or I have 100's of old products in New Products. Where is this being called? Any ideas on a fix. Thanks.

The best way to fix this would be upgrade your Easypopulate to the one I added in the mods. This will allow you to custom your downloaded file and instead of having model/price/quantity you could make it model/price/quantity/DATE ADDED then you will be good to go.

Adam

[bkpie]

Adam:

Thanks I will look into it. Also another problem I have is I use an out of stock contribution so if I put zero into quantity but leave product active it shows out of stock and then they can click to be emailed when instock. But Easypopulate sees the zero and makes the product inactive. Does your new contrib handle this or do I have to find another fix for that. Thanks again

[ALElder]

Sorry it does not have that option but I think if you are doing a update on model/price/quantity/DATE ADDED it does not even look at the stock I might be wrong. Let us know maybe should be an option to turn on or off that feature.

[bkpie]

It still does look at active and inactive based on quantity. I have messed with the easypopulate.php where I can find anything that deals with stock or quantity but it still does it. Everytime there is a zero it deactivates it and in the reverse if you have a product showing quantity but have it deactivated for some reason it activates it on you.

[bkpie]

Ok here is where I think it is. In both the old and new version in configuration there is this

// If zero_qty_inactive is true, then items with zero qty will automatically be inactive in the store.
define ('EP_INACTIVATE_ZERO_QUANTITIES', false); // default is false

This should take care of the staying active with zero quantity problem. I would think

However I think there needs to be a line in config so if you have a product that is inactive but shows quantity it stays inactive if you want it to be. Otherwise it activates the product based on I believe line 2151 below on ALelders new contrib and can also be found in the previous version. I marked it with problem is here.

// default the stock if they spec'd it or if it's blank
if (isset($v_status_current)){
$v_db_status = strval($v_status_current); // default to current value
} else {
$v_db_status = '1'; // default to active (PROBLEM IS HERE)
}
if (trim($v_status) == EP_TEXT_INACTIVE){
// they told us to deactivate this item
$v_db_status = '0';
} elseif (trim($v_status) == EP_TEXT_ACTIVE) {
$v_db_status = '1';
}

Adam or anyone have an idea to fix that one?

[ALElder]

Thanks for the feedback,

* I did look at the Active/InActive status your brought up and Found all you need to do in the status is keep it InActive and it will keep that setting.

Hope this help also hope you like the Delete feature.

Adam

[bkpie]

Originally Posted by ALElder

Thanks for the feedback,

* I did look at the Active/InActive status your brought up and Found all you need to do in the status is keep it InActive and it will keep that setting.

Hope this help also hope you like the Delete feature.

Adam

You are right that everything works just like you said as long as SPPC is set to false. It works wonderfully. Since I use SPPC when I set that to true in configuration I then get

1136 - Column count doesn't match value count at row 1

INSERT INTO products_groups VALUES ( 1, 2.9400, 5 )

I have played with all the cofig variables. If I put in the old ep that works but as I said earlier I need the features of yours or I get the date added problem

Another note: When sppc is set to false date added is fine but when true I noticed it is just #######

Maybe I am missing something simple but sometimes when you have looked at something as long as i just have you can miss something simple. Any ideas?? Thanks for your help in advance

[bkpie]

Ok here is what I figured out but maybe there is an easier fix but all works for me now with SPPC set to true in easpopulate configurations. There was a bug fix that on April 9th with the original version for Osc MS2. This was incorporated into version 2.76e f etc. This removed a needed column not needed for MS2 but needed for OSCmax.

The fix for MS2 was

INSERT INTO '.TABLE_PRODUCTS_GROUPS.'
VALUES
(
' . $v_customer_group_id_1 . ',
' . $v_customer_price_1 . ',
' . $v_products_id . ',
' . $v_products_price .'
)'
);
------------------
WITH
------------------

INSERT INTO '.TABLE_PRODUCTS_GROUPS.'
VALUES
(
' . $v_customer_group_id_1 . ',
' . $v_customer_price_1 . ',
' . $v_products_id . '
)'
);

So what I had to do was the reverse and add . $v_products_price .' back in (4 places) in easypopulate.php around line 2593

I am also only using 3 customer groups so I uncommented group 4 in this section of easypopulate.php so it looks like this around line 1399

if (EP_SPPC_SUPPORT == true) {
$ep_additional_layout_pricing .= '$filelayout[\'v_customer_price_1\'] = $iii++;
$filelayout[\'v_customer_group_id_1\'] = $iii++;
$filelayout[\'v_customer_price_2\'] = $iii++;
$filelayout[\'v_customer_group_id_2\'] = $iii++;
$filelayout[\'v_customer_price_3\'] = $iii++;
$filelayout[\'v_customer_group_id_3\'] = $iii++;
#$filelayout[\'v_customer_price_4\'] = $iii++;
#$filelayout[\'v_customer_group_id_4\'] = $iii++;
Note above group 4 is uncommented

SPPC all working for me now hope this helps someone.

[chrisbarbers]

Yep that is the fix to make the latest version of easypopulate work with osCMax 2.0 RC3, but remember if you update to any future versions of easypopulate the creator is not supporting 4 fields "until someone can explain the need for it", so you will have to make the same change to any updated ep releases or you wind up with the same problem, probably best to keep a file on your server noting what files are modded.