FREE script - Prestools-Suite mass edit order - Edit and much more

[SandroR1 6]

Hi Sandro,

 

Thank you for your explanation. I am not familiar with any change in the code that could explain such a difference. 

 

Attached I have two older versions. Could you check them to see whether they have the same problem for you or not? That would help me pinpointing the problem.

 

Hello Musicmaster,

 

I've tested both versions (1.16f and 1.14o2) and I have not found any problem: after "submit" show updated data immediately, without the need to clear the browser cache.

 

If you want, I can control other releases, there is no problem.

 

Thank you.

 

Hi.

 

-

 

Sandro R1

[smalto 1]

Hi Musicmaster,

 

What I mean is that when I sort the product visualy I change the product place and rearrange the product on the page. Then I click submit for the changes to be online (and on the website the changes are ok) but then on the visual sorting page the products are like previously not like the changes that have already be done. This is why I was wondering if it is possible to have an automatic refresh instead of doing it manually ?

[musicmaster 678]

Hi Musicmaster,

 

What I mean is that when I sort the product visualy I change the product place and rearrange the product on the page. Then I click submit for the changes to be online (and on the website the changes are ok) but then on the visual sorting page the products are like previously not like the changes that have already be done. This is why I was wondering if it is possible to have an automatic refresh instead of doing it manually ?

Hi Smalto,

 

Do you have a recent version? I cannot see the problems you mention. The only problem I found is one with multi-shopping - that will be solved in the next release.

 

Otherwise can you pm me your access data so that we can have a look together?

[smalto 1]

Hello Musicmaster,

 

I have now tried on Chrome and the refresh is done automatically. In Firefox for mac 51.0.1 the refresh is not automatic.

So it seems that it is related to the browser and not to your script. I will use Chrome on my mac when I use your script.

Thank you.

[musicmaster 678]

Hello Musicmaster,

 

I have now tried on Chrome and the refresh is done automatically. In Firefox for mac 51.0.1 the refresh is not automatic.

So it seems that it is related to the browser and not to your script. I will use Chrome on my mac when I use your script.

Thank you.

Thank you for the feedback.

[ietax 11]

Hi, I used your script for a long time... but now I have only forst row inside table...

 

others line are out of table and I cannot edit fileld.. can you help me? thanks

[musicmaster 678]

Hi, I used your script for a long time... but now I have only forst row inside table...

 

others line are out of table and I cannot edit fileld.. can you help me? thanks

 

Hi ietax,

 

Sorry to hear you found a problem.

 

I have to see this to know what is happening. Can you pm me access data so that I can have a look? Or do you have a screendump?

 

Are you using the latest version? It is recommended to update first when you experience a problem. There is always a chance that the problem has already been solved. And if there are error messages it makes them easier to locate.

 

M.

Edited March 18, 2017 by musicmaster (see edit history)

[musicmaster 678]

Hello Musicmaster,

 

I've tested both versions (1.16f and 1.14o2) and I have not found any problem: after "submit" show updated data immediately, without the need to clear the browser cache.

 

If you want, I can control other releases, there is no problem.

 

Thank you.

 

Hi.

 

-

 

Sandro R1

 

Hi Sandro,

 

I have two new versions. Can you test them too?

 

Regards,

 

M.

Prestools_Suite-1.16fx.zip

Prestools_Suite-1.16fy.zip

[SandroR1 6]

Hi Sandro,

 

I have two new versions. Can you test them too?

 

Hello Musicamaster,

 

I've tested both versions (1.16fx and 1.16fy) and both function properly and DO NOT require the cache refresh (F5 or ctrl + F5) and show immediately changes made (I have only tested this feature, I have not checked nothing else!).

 

I have found that in these versions there is no longer the ability to search in the field "available_for_order", which instead was present in the 1.14e release (screenshot attached).

 

Thanks for everything.

 

Hello.

 

--

 

Sandro

[SandroR1 6]

Hello Musicmaster,

I also checked the latest version 1.16p (1.16n in the footer) and, unfortunately, you must update the cache with ctrl + F5 after the changes.

Hi.

 

--

 

Sandro

[musicmaster 678]

Hi Sandro,

 

Hereby two new tryouts.

 

I will re-introduce  "available_for_order" in the next version. It had bene stripped out when I combined it with "show_price".

 

cheers,

M

Prestools_Suite-1.16fa.zip

Prestools_Suite-1.16fb.zip

[SandroR1 6]

Hi Sandro,

 

Hereby two new tryouts.

 

Hi Musicmaster,

 

1.16fa and 1.16fb are ok (updates instantly after submit without refresh).

 

Hi.

 

--

 

Sandro

[dojek 0]

Hello,

 

I have problem, when I would like to confirm update nothing really hapens:

 

https://www.screencast.com/t/2e1JWzw44J5B

 

 

Prestashop version: 1.6.1.11

 

Can you help me please? 

[musicmaster 678]

 

Hello,

 

I have problem, when I would like to confirm update nothing really hapens:

 

https://www.screencast.com/t/2e1JWzw44J5B

 

 

Prestashop version: 1.6.1.11

 

Can you help me please? 

 

Sorry, I have no flash installed

[musicmaster 678]

Hi Sandro,

 

Two new chances...

 

Regards,

M

Prestools_Suite-1.16fc.zip

Prestools_Suite-1.16fd.zip

[KevinNash 119]

 

Hello,

 

I have problem, when I would like to confirm update nothing really hapens:

 

https://www.screencast.com/t/2e1JWzw44J5B

 

 

Prestashop version: 1.6.1.11

 

Can you help me please? 

 

 

Hello, as instructed you must make the field editable by ticking edit on it before you can mass update the editables records.

[SandroR1 6]

Hi Sandro,

 

Two new chances...

 

Hi Musicmaster,

 

release 1.16fc shows the updated data immediately, instead rel. 1.16fd NOT shows immediately the changes and requires refreshing of the F5.

 

Found! 

 

Hi.

 

--

 

Sandro

[musicmaster 678]

Hi Musicmaster,

 

release 1.16fc shows the updated data immediately, instead rel. 1.16fd NOT shows immediately the changes and requires refreshing of the F5.

 

Found! 

 

Hi.

 

--

 

Sandro

I think it is .htaccess. I had changed that when some people appeared to load old versions of the javascript file. But it looks like the changes don't work out well in some settings. So I will undo the changes.

 

Thank you for your help finding this out.

[SandroR1 6]

Thank you for your help finding this out.

 

Thank YOU! Prestools is invaluable!

 

Hi.

 

--

 

Sandro

[SandroR1 6]

Hi Musicmaster,

 

the new release 1.16q works perfectly and does not require updating the cache after changes.

Thanks also to have added available_for_order to search fields.

Thank you very much.

Hi.

 

--

 

Sandro

[josh@nerdopia.co.uk 0]

HI Musicmaster

 

Is there an option to default submit to all shops?

 

Thanks again

[czt 3]

Hi.

I How to edit combinations massively. Each combination has a different price

Thank you .

[musicmaster 678]

Is there an option to default submit to all shops?

 

No.  But I could consider adding one. On the other hand: changing the source code should be rather easy for anyone knowing a bit of html.

 

I How to edit combinations massively. Each combination has a different price

 

Products with combinations have as their quantity field a link. If you click that link you get on the combinations page of that product where you can change prices, etc. An alternative road is the combinations field.

[josh@nerdopia.co.uk 0]

Thanks if you could add it as everytime you update I'd assume I would have to recode that would be most appreciated!

 

I will have a play anyway 

[romelik 3]

Hello

I've bought the features plugin one month ago... and it's the first time I want to use it, but I don't understand why there is " 3 circles " for edit, and nothing happened when I checked each of them and I couldn't change features...

Could you help me please...

[musicmaster 678]

The three circles have to do with a different interface, for example the choice between a line and a textarea input. They should work all three.

 

That they are not working suggests that some javascript error is happening. If you can give me access (by PM) I can have a look and solve the problem for you.

[romelik 3]

Thanks for your reply ... In the console, you're right there's javascript error.

I send you mp...

[romelik 3]

Error js is featurelist is not defined ... in product-edit2.js

[musicmaster 678]

The problem was that one of the pre-defined feature values had a linefeed in it. In the next update there will be a fix to handle such cases. See also the attached file.

product-edit.php

Edited April 6, 2017 by musicmaster (see edit history)

[Ben90 29]

Hi MusicMaster

 

I've been using Prestools Package 1.03 and Prestools Suite 1.10. I would like to add 1 delivery method to all product in a particular category. It returns with error 404.

 

The link is /prestools/product-proc.php?c=18&d=18

 

I've just edited some categories and it was working fine, then this particular category & sub-categories didn't work.

 

Any idea what's happening?

[musicmaster 678]

Hi MusicMaster

 

I've been using Prestools Package 1.03 and Prestools Suite 1.10. I would like to add 1 delivery method to all product in a particular category. It returns with error 404.

 

The link is /prestools/product-proc.php?c=18&d=18

 

I've just edited some categories and it was working fine, then this particular category & sub-categories didn't work.

 

Any idea what's happening?

Hi Ben,

 

I am puzzled by this problem. 404 (file not found) is a very unusual error to experience in this context. It might help if you could provide the url of the not found file. The only situation where I found 404's were in the case were some antispam program had renamed or deleted the product-proc.php file.That happens usually after a couple of minutes - what might explain that it initially works ok.

 

"?c=18&d=18" doesn't say much. The real info is transferred invisible (the POST option in html).

 

If you PM me access data and tell me how to reproduce the problem I will have a look.

 

An alternative is that you switch verbose on and report to me the output both with a category where it works and a category where it doesn't work.

 

M

Edited April 7, 2017 by musicmaster (see edit history)

[neouy 3]

Hello, I need to copy massive combinations in prestashop 1.7, is it for that prestashop version? where do I buy it?

Thanks and great work

[Ben90 29]

Hi Ben,

 

I am puzzled by this problem. 404 (file not found) is a very unusual error to experience in this context. It might help if you could provide the url of the not found file. The only situation where I found 404's were in the case were some antispam program had renamed or deleted the product-proc.php file.That happens usually after a couple of minutes - what might explain that it initially works ok.

 

"?c=18&d=18" doesn't say much. The real info is transferred invisible (the POST option in html).

 

If you PM me access data and tell me how to reproduce the problem I will have a look.

 

An alternative is that you switch verbose on and report to me the output both with a category where it works and a category where it doesn't work.

 

M

 

Hi M,

 

I ticked the verbose but the result is still the same. It returns 404. I tried on a different category too & it seems like the result is the same.

 

Do you think it's because I renamed the carrier? But it shouldn't cause an error.

 

Please check your PM. Thanks

[musicmaster 678]

 

Hello, I need to copy massive combinations in prestashop 1.7, is it for that prestashop version? where do I buy it?

Thanks and great work

 

 

Hi neouy,

 

I need to make some minor adaptations to make combination copying work under 1.7 as Prestashop has added a new field (ISBN). I hope to include it in the next update. With the free version you can only copy combinations for one product at a time. If you buy the plugin (at Prestools.com) you can copy to as many products as you want.

 

 

 

. 

[neouy 3]

Hi neouy,

 

I need to make some minor adaptations to make combination copying work under 1.7 as Prestashop has added a new field (ISBN). I hope to include it in the next update. With the free version you can only copy combinations for one product at a time. If you buy the plugin (at Prestools.com) you can copy to as many products as you want.

 

 

 

. 

Perfect thank you very much, I want to buy to copy many combinations at the same time, my prestashop is 1.7.1.0, you can notify me when you are ready to buy?

[vladip 1]

Hi,

again prestools doesn't save anymore. I worked yesterday without any problem but in the afternoon, without any advise, it was not possible anymore to save changement.

Today I update to the last version and it save the first change (!) and after that no more. Of course I emptied the cache without results. Any solution?

[musicmaster 678]

Hi,

again prestools doesn't save anymore. I worked yesterday without any problem but in the afternoon, without any advise, it was not possible anymore to save changement.

Today I update to the last version and it save the first change (!) and after that no more. Of course I emptied the cache without results. Any solution?

Hi Vladip,

 

Is it possible for you to pm me access to you Prestools page so that I can have a look myself?

 

My guess is that you have some kind of data that causes a javascript error. But I have to look to know more.

[musicmaster 678]

 

Hello, I need to copy massive combinations in prestashop 1.7, is it for that prestashop version? where do I buy it?

Thanks and great work

 

Hi Neouy,

 

Can you try the new version?

[neouy 3]

Hi Neouy,

 

Can you try the new version?

 

Yes of course, how do I do?

[musicmaster 678]

Yes of course, how do I do?

Just download and install. And copy your combinations...

[musicmaster 678]

At post #1 of this forum thread you can download the software. The post contains also a description how to install (NOT as a module!) and a manual.

[romelik 3]

Hello

Is it possible to delete some combinations or in mass with product-combination edit free version or not

Thanks

[musicmaster 678]

Hello

Is it possible to delete some combinations or in mass with product-combination edit free version or not

Thanks

Yes, But in the free version you can do it only with one product at a time.

[romelik 3]

OK could you explain please for free version if that OK I'll buy your plugin???

But in product-edit I checked "Combinations", I clicked on the number of combination and in the new window I don't see any delete button only "Hide display"

Could you help me please??

[musicmaster 678]

Combination copy and combination delete are separate functions that have their own entry in the menu at the top.

[romelik 3]

OK and with plugin version is it possible to delete only some combinations of one or several products??

[musicmaster 678]

OK and with plugin version is it possible to delete only some combinations of one or several products??

I am not sure what you mean. You can select which combinations to delete with the free version too. The limitation is that you can apply to only one product at a time.

[romelik 3]

Yes you 're right, I just see it I test it but when I check "select combinations from product" no combinations are displays...

Some pictures explain to you

I 've a product ID 2011 with 3 combinations

 

when I checked on combination-edit I see this 3 combinations: 

 

But in combination delelete no choice for deleting for example the 2nd combination

 

Maybe I've don't undersand...

Edited April 19, 2017 by romelik (see edit history)

[musicmaster 678]

Your pictures are dead links

[romelik 3]

Yes I fix it sorry...

[musicmaster 678]

You didn't fill in a product id. You need to mention a "master product" whose attributes are listed. You can then delete those from any product.

[romelik 3]

okkkk...!!! but so I don't understand Target ID...???

 

I tried but I 've a alert :"This version of Combi-copy CANNOT be used with this version of Prestashop!"

My prestashop version 1.6.1.4.

 

Edit: I've 17rows in ps_product_attribute and not 16... why???Do you no?

 

In fact it's not 17rows but 17columns...

Edited April 19, 2017 by romelik (see edit history)

[josh@nerdopia.co.uk 0]

Hi musicmaster

 

Me again

 

When using your new active drop down box it seems to ignore any info I put in find fields. Tried with a few like name and qty and all it seems to display is what I selected in active field

[musicmaster 678]

Hi Bussterj,

 

Thanks for catching that bug. I fixed it for you.

[josh@nerdopia.co.uk 0]

Hey Musicmaster

 

That seems to have broken something

 

The attached is displayed

Edited April 26, 2017 by bussterj (see edit history)

[musicmaster 678]

I see that I had left some debug code (the query) in the page - that is no repaired. But this doesn't affect the results. 

 

Are you sure that the category in which you are searching contains this word? If I look on your site it is in a subcategory of it.

[josh@nerdopia.co.uk 0]

I edited my post i hadn't clicked subfolders.

 

So all i was reporting was the debug code sorry for the confusion

Edited April 26, 2017 by bussterj (see edit history)

[musicmaster 678]

I edited my post i hadn't clicked subfolders.

 

So all i was reporting was the debug code sorry for the confusion

No problem. It was good that you alerted me to remove that debug code. 

[musicmaster 678]

The indexation system of Prestashop has some deficiencies. It does not index supplier references (it has code for it but that has been outdated for at least five years) and of the categories that a product belongs to it only indexes the default one. I hope that the first problem will be repaired in the following edition of PS 1.7 - but that doesn't help all those using older versions.

 

With 1.17d I have solved those two problems for the indexation in Prestools. So products last changed with Prestools will contain the improved indexation. If you next change the product in Prestashop you will get its indexation again. 

 

Note that in Prestools only fields relevant for indexation trigger re-indexation. Price changes for example will not do so. An easy way to trigger re-indexation is to change products to inactive, then change them back to active and them to submit all. Note that as you don't submit in between the products are never inactivated: you just fooled the software that the active field had been changed.

[seog 2]

You can already edit the supplier reference with the plugin. But I am not sure what you mean with the "product sheet".

 

Thank you very much for your work. I download today your module but I can´t see supplier_reference for edit. I see in product-edit.php around line 1210 where you allow supplier reference if dont exist product reference "p.reference ".$inc." or p.supplier_reference"

 

There are a way to can choose and edit p.supplier_reference ?

 

best regards

Edited May 1, 2017 by seog (see edit history)

[musicmaster 678]

Thank you very much for your work. I download today your module but I can´t see supplier_reference for edit. I see in product-edit.php around line 1210 where you allow supplier reference if dont exist product reference "p.reference ".$inc." or p.supplier_reference"

 

There are a way to can choose and edit p.supplier_reference ?

 

best regards

 

 

Line 1210 is about the search function in Prestools. Besides that it is not correct. p.supplier_reference is a heritage field that no longer has a function. The supplier reference field is now in the ps_product_supplier table. So I will need to fix or remove this here.

 

You can edit the supplier reference by choosing to edit the supplier.

Edited May 3, 2017 by musicmaster (see edit history)

[romelik 3]

Hello I've bought your features plugin and override my prestashop to be able to save multi features value...

In product-solo I saw all my features value : ex: Size 10cm, 20cm, 30cm... but in product-edit I saw only tle last value so 30cm ... is it possible to display all the values??

Thank you...

[musicmaster 678]

Hello I've bought your features plugin and override my prestashop to be able to save multi features value...

In product-solo I saw all my features value : ex: Size 10cm, 20cm, 30cm... but in product-edit I saw only tle last value so 30cm ... is it possible to display all the values??

Thank you...

That is doubtful....

 

The problem is that what you have is a customization. That plugin makes changes to the standard Prestashop database and I don't know which one. Accidentally it works ok with product-solo but I don't know why.

 

So I would need to have a closer look first before I can say more.

[romelik 3]

I've made the override of this post by  jgullstr the 21 august 2014 in page 9

https://www.prestashop.com/forums/topic/176242-modification-select-multiple-values-for-one-feature/page-9/#post_id_1771267

In the database in ps_feature_product I change the primary key existing to a combination of the three values : id_feature, id_product and id_feature_value.

In your script in product-solo.php you have all the features_value with this query:

foreach($features AS $key => $feature)
	{ $xquery = "SELECT fv.custom AS custom,fl.value AS value FROM ". _DB_PREFIX_."feature_product fp";
	  $xquery.=" left join ". _DB_PREFIX_."feature_value fv on fp.id_feature_value=fv.id_feature_value";
	  $xquery.=" left join ". _DB_PREFIX_."feature_value_lang fl on fp.id_feature_value=fl.id_feature_value AND fl.id_lang='".$id_lang."'";
	  $xquery .= " WHERE fp.id_product = '".$id_product."' AND fp.id_feature='".$key."'";
	  $xres=dbquery($xquery);
	  while ($xrow=mysqli_fetch_array($xres)) /* mag maar één keer gebeuren */
	  { echo "<tr><td>".$key."-".$feature."</td><td>";
	    if($xrow["custom"] == "1") echo $xrow["value"];
		else echo "<b>".$xrow["value"]."</b>";
		echo "</td></tr>";
	  }
	}

I tried to put it in product-edit but with no succes... if you 've a idea... thank you

Edited May 8, 2017 by romelik (see edit history)

[musicmaster 678]

In line 2134 of product-edit.php you have the following

foreach($features AS $key => $feature)
{ $cleanfeature = str_replace('"','_',$feature);
  if (in_array($cleanfeature, $input["fields"]))
  { if($datarow['value'.$key] == "")
		echo "<td></td>";
	else if($datarow['custom'.$key] == "0")
  	    echo "<td><b>".$datarow['value'.$key]."</b></td>";
	else // custom = 1
  	    echo "<td>".$datarow['value'.$key]."</td>";
	  
/*  if($datarow['value'.$key] != "")
  	    echo "<td idx='".$datarow['custom'.$key]."'>".$datarow['value'.$key]."</td>";
	else
  	    echo "<td idx='-1'></td>";
*/  }
}

In your case you will get after the line "if (in_array($cleanfeature, $input["fields"]))" an extra "if" for your multi-value features and for them you can then copy the code from product-solo. Of course those values will be view-only as the software isn't designed for handling multi-value features.

[romelik 3]

Maybe for someone else ... I achieved something...

$display_multi_features_value = 1;
if ($display_multi_features_value == 1){
	echo "<td>";	
	foreach($features AS $key => $feature)
	{ $xquery = "SELECT fv.custom AS custom,fl.value AS value FROM ". _DB_PREFIX_."feature_product fp";
	  $xquery.=" left join ". _DB_PREFIX_."feature_value fv on fp.id_feature_value=fv.id_feature_value";
	  $xquery.=" left join ". _DB_PREFIX_."feature_value_lang fl on fp.id_feature_value=fl.id_feature_value AND fl.id_lang='".$id_lang."'";
	  $xquery .= " WHERE fp.id_product = '".$datarow['id_product']."' AND fp.id_feature='".$key."'";
	  $xres=dbquery($xquery);
	  while ($xrow=mysqli_fetch_array($xres)) /* mag maar één keer gebeuren */
	  { echo "<p>".$key."-".$feature.":";
	    if($xrow["custom"] == "1") echo $xrow["value"];
		else echo "<b>".$xrow["value"]."</b>";
		echo "</p>";
	  }
	}
}
else
	foreach($features AS $key => $feature)
	{ $cleanfeature = str_replace('"','_',$feature);
	  if (in_array($cleanfeature, $input["fields"]))
	  { if($datarow['value'.$key] == "")
			echo "<td></td>";
		else if($datarow['custom'.$key] == "0")
	  	    echo "<td><b>".$datarow['value'.$key]."</b></td>";
		else // custom = 1
	  	    echo "<td>".$datarow['value'.$key]."</td>";
	  
/*	  if($datarow['value'.$key] != "")
	  	    echo "<td idx='".$datarow['custom'.$key]."'>".$datarow['value'.$key]."</td>";
		else
	  	    echo "<td idx='-1'></td>";
*/	  }
	} 

 I change in the sql request : ".'id_product'." by ".$datarow['id_product']." else i 've error : "variable id_product' is not defined."

 

With this code I must write the value of my new variable $display_multi_features_value to display it, if it's possible I would like that :

$display_multi_features_value == 1  by default, if features is not checked

and  $display_multi_features_value == 0 if features is checked  but I don't understand how you check your checkbox...

[musicmaster 678]

Hi Romelik, 

 

Compliments for finding a solution.

 

The checkboxes are the array $input["fields"]. If a field is checked you find it in the array. Otherwise not.

 

So if you had multiple values for the features "cars" and "trucks" I would expect the following kind of code to work (untested so it may contain some bugs, but you know how to code):

$multivalue_features = array("cars","trucks");
foreach($features AS $key => $feature)
{ $cleanfeature = str_replace('"','_',$feature);
  if (in_array($cleanfeature, $input["fields"]))
  { if (in_array($cleanfeature, $multivalue_features))
    { echo "<td>"; 

$xquery = "SELECT fv.custom AS custom,fl.value AS value FROM ". _DB_PREFIX_."feature_product fp";

   ....

} else { if($datarow['value'.$key] == "")

[radik94 0]

The download links ar not working, can someone give me them?

[musicmaster 678]

The download links ar not working, can someone give me them?

On the whole Prestashop forum the download links are failing. I hop they repair this soon.

 

In the meantime you can download the software from the bottom of the www.prestools.com homepage.

[musicmaster 678]

There was a little bug fix for the paid suppliers plugin. People who have this plugin or the whole package are encouraged to upgrade. They should simultaneously upgrade the free software to 1.17f or higher.

 

The bug concerned the currency. There was no option to set it and always the default currency was used. As far as I know know it didn't cause problems for anyone. 

Edited May 13, 2017 by musicmaster (see edit history)

[ptolemy 1]

ok. Thank you

[Piotr K. 34]

Hi Musicmaster, Thanks for your plugin.

When select warehouse, warehousing column is empty. Warehousing is not editable.

Export CSV - warehousing column = qty column.

In CSV file: Notice:  Undefined index: supplier in ..../product-csv.php on line 610.

Prestashop 1.6.1.13. Prestools 1.17f. PHP 7.

Best regards

[musicmaster 678]

Hi Piotr,

 

Stock keeping with a warehouse is not supported in Prestools, except for a few little things. First of all you can see - but not change - your stock in warehouses when you select the warehouse field. The second is that if you select the "stockflags" field and you choose to change from manual to Adv Stockmanagement with Warehousing  you have the option to move the existing stock to a warehouse (in Prestashop the stock is set to zero).

 

Demand was too low and it is quite complicated, so I never came to implement this. And with 1.7 ASM was dropped....

 

I will have a look at the CSV. It looks like the supplier isn't handled correctly. I will repair that in the next update.

 

Regards,

M

[musicmaster 678]

The update is there.

[Piotr K. 34]

Hi Musicmaster,

Thanks for your reply.

Unfortunately I can not see.

If I find warehouse 0 or 1 or 2 or 3 products not found.

Warehouse/warehousing column is the quantity of products in the warehouse or warehouse id?

Regards,

Piotr

[musicmaster 678]

Warehousing displays now just the total quantity. If you want I can change it to what you see online. But I am not sure how to implement a nested array in csv. So either you would get name and quantity of one warehouse or you would get a list of warehouse names without quantity. 

 

It is not clear to me what you are aiming for with "find 1 in warehousing".

[Piotr K. 34]

Thank you.
I thought I could choose a warehouse id.
I wanted to see which warehouse are assigned to the product.
Depending on the warehouse, I set shipping cost

Regards

[musicmaster 678]

ok, new update

[Piotr K. 34]

Great! I'll test and let you know. Thank you very much.

[Piotr K. 34]

Hi Musicmaster,
Thank you for your time and job.
I have tested the new version and unfortunately, it's not working in my case. What I need it's an information about the product location (which warehouse), quantity are not interested me.
If is it possible to show warehouses and export .csv data in the same way as suppliers?
As I see at this moment warehouse data are select from ps_stock table, don't You think that it should be select from ps_warehouse_product_location (table ps_stock ist empty in my store)?
Or maybe is that modification should be done by myself?
I hope I didn't mix to much...

Thank You
BR

Edited June 2, 2017 by Piotr K. (see edit history)

[musicmaster 678]

Hi Musicmaster,

Thank you for your time and job.

I have tested the new version and unfortunately, it's not working in my case. What I need it's an information about the product location (which warehouse), quantity are not interested me.

If is it possible to show warehouses and export .csv data in the same way as suppliers?

As I see at this moment warehouse data are select from ps_stock table, don't You think that it should be select from ps_warehouse_product_location (table ps_stock ist empty in my store)?

Or maybe is that modification should be done by myself?

I hope I didn't mix to much...

Thank You

BR

Hi Pjotr,

I will have a look at it.

I suspect that somewhere between version 1.5 and 1.6 the role of the ps_stock table has been changed, but it will take some study to check that out.

[Piotr K. 34]

So in my tests (prestashop 1.6.1.13):

The warehouse in which the product is stocked - Catalog -> Product edit -> Warehouses tab -> table ps_warehouse_product_location

 

The available quantities for the product and its combinations based on the stock in warehouse (using the advanced stock management system) - Stock -> Stock Management -> table ps_stock.

 

PS: At end of export.csv file is

?>

[musicmaster 678]

Hi Pjotr,

 

Can you try the attached files?

 

 

product-csv.php

product-edit.php

[Piotr K. 34]

Hi Musicmaster.

Excellently!
It seems that everything is working properly.

 

Attached slightly corrected product-csv.php file

 

Thank You
BR

product-csv.php

[musicmaster 678]

Hi Musicmaster.

Excellently!

It seems that everything is working properly.

 

Attached slightly corrected product-csv.php file

 

Thank You

BR

Thank you for helping to improve Prestools!

[KevinNash 119]

Hello musicmaster,

 

Module Info doesn't work because module-info.php file is missing, can you take a look ?

[musicmaster 678]

Hi Kevin,

 

Thank you for the report.

 

I has been fixed.

[mariog1233 0]

When i set VAT in Suite and confirm it i can see everything normaly and OK. But when i check those products in admin there is no VAT. Is there any bug or is there some problem at me.