newcomer

I can confirm unlimitedgrain solution works. However in my case the id_page_type is 2. You need to find what is the correct id page type for "product" in ps_page_type.

Also having the same problem. Has this been fixed that we aren't aware of?

Hi guys. I'm trying to disable a carrier, Carrier A, whenever batteries are added to cart because airlines wouldn't accept them. This is working so far as long as the cart only contains batteries, which Carrier A would be normally disabled. At this point everything is working fine. However, when I added a non sensitive item to cart, Carrier A suddenly becomes available. Obviously this is a bug because it would force me to ship the batteries using Carrier A which I have not assigned it to. Can anyone point me in the right direction to edit the php file that is exhibiting this behaviour?

Hi does anyone know if it's possible to do that using SQL Manager in BO? So if I have: 1 a 1 b 1 c 2 a 2 c 2 d I would like to get 1 a b c 2 a c d Same with multicolumn. if I have 1 a b c 1 d 2 e f g h 2 i j Would like to get 1 a b c d 2 e f g h i j Perhaps using the PIVOT command? Does Prestashop SQL Manager allow that? If not how would one go about typing out the syntax?

Hmm I noticed this as well. However in database ps_warehouse_carrier the Carrier ID doesn't get updated, it remained as it were the first ID assigned. Is this how it's supposed to work?

Actually you can import csv wholesale price into the ps_specific_price table in SQL. But yes your right there is no function to turn on visibility of specific price for products to say wholesale customers.

Looking for an answer too. Anyone? Found a somewhat incomplete solution: inside price.tpl you have access to $employee object, so find the HTML code that contains wholesale price (there is <div class="form-group"> ... </div>) and wrap it in next condition: {if $employee->id_profile == 1} <div class="form-group"> ...html code... </div> {/if} where 1 it is Id for SuperAdmin profile by default. Anyone can help with a complete coding?

You can't do multiple warehouses and suppliers in csv product import. I have tried all kinds of formats in the csv file it just wouldn't work. In the end I had to create a new csv file and import it from SQL at cpanel>phpmyadmin. Take note CSV import at SQL requires individual fields to have open and closed quotes. Excel alone can't do this so you will have to run some custom macro in VB for excel to export the correct format in CSV. For exporting excel to CSV with quotes by running a macro see link below: https://support.microsoft.com/en-us/kb/291296

Follow this link to download the patch search.php to replace the one in your /classes folder. It works for me. Am on 1.6.0.14 https://www.prestashop.com/forums/topic/509403-problem-in-indexing-rebuilding-search/?p=2269424

I'm on 6.0.14 too and I have fixed the problem by replacing the search.php file with another one provided by the kind souls here. You may read this thread for more info: https://www.prestashop.com/forums/topic/421756-blank-screen-when-adding-missing-products-to-index/ That thread attachment has expired so here I upload it again for anyone with the same problem. Search.php

Need this badly too. Any love for 1.6?

I too am confused about the UPTE in the Price Tab and Supplier Tab. They seem to be different thing yet share the same name.

Having this issue too. Do you mind sending the developer contact to me too?

How do turn off thumbnail generation during import csv?

Any help would be much appreciated thanks

Hi, When using mobile phone, or when i set the pc screen size to 760px wide or less, the links like Sign In, Contact Us and dropdowns such as Currency and Language aren't working. Nothing happens when you hover over them in pc mode and it's not responding to touch on mobile. The only thing I have changed with the navigation bar is hooking my shopping cart to it. Can anyone help please? Link: www.idsairsoft.com Attach screen shot.

Just got this problem

Would like to know how to do this too. Anyone?

For the null method to shop_id, you need to enable the NULL option under the "Structure" tab.

So I installed Prestashop Cleaner and cleaned the database. Now it seems to be working fine. I also found out if I did not include the unit price (tax exclusive), the real qty will be deducted instead of added. Weird behavior. I created an extra status No.7 and called it => 7 - Order received incomplete (Closed). This process should be selected if an order arrived incomplete or somewhat different than ordered. It should be selected right after 3 - Pending receipt. It's actually the same as 6 - Ordered canceled but I think it would be better to create a new status that had a more reasonable status naming. See attached picture: Edit: Except for one little bug. Order valuation is not calculated based on the actual qty received but qty ordered.

I did notice that in Supply Order mode, one cannot set if the product is *Usable for sale like how it can be set if one were to the clumsy Stock Management>Add Stock. Perhaps this might be a bug? Supply Order disabled qty for sale by default?

I have researched the shit out of the internet to resolve this issue but none has been successful so far. It is surprising to see such a widespread problem being mostly ignored by PS developers. No less than a dozen topics regarding this bug has been opened but none were resolved. Following are links that I have compiled that discussed the main problem of ASM. https://www.prestashop.com/forums/topic/478085-advanced-stock-management-supply-order-does-not-add-stock-at-all/ https://www.prestashop.com/forums/topic/479413-advanced-stock-management-supply-order-is-not-updating-quantities/ https://www.prestashop.com/forums/topic/481653-no-partial-delivery-in-1612-stock-management/ https://www.prestashop.com/forums/topic/1568[spam-filter]understanding-advanced-stock-management/ https://www.prestashop.com/forums/topic/282625-stock-will-not-auto-update-after-receiving-supply-order/ https://www.prestashop.com/forums/topic/316173-advanced-stock-man-and-supply-order-broken-in-16/ https://www.prestashop.com/forums/topic/336474-1606-advanced-stock-management/ https://www.prestashop.com/forums/topic/318609-supply-orders-and-statuses/ https://www.prestashop.com/forums/topic/158246-supplier-order-system/ https://www.prestashop.com/forums/topic/290335-stock-supply-orders-and-stock-management-do-not-work/ https://www.prestashop.com/forums/topic/288896-adding-stock-through-a-supply-order-does-not-work/ https://www.prestashop.com/forums/topic/199983-advanced-stock-management-supply-orders-problem/ https://www.prestashop.com/forums/topic/198620-multishop-stock-quantity-problems/#entry989340 Related folders in root directory: .../public_html/classes/stock .../public_html/controllers/admin/AdminSupplyOrdersController.php Following are fixes found on github and forge. Tried but did not work. Maybe I did something wrong. https://github.com/PrestaShop/PrestaShop/commit/ da2ab7a4404282c33d7846d219da4959fc11c641 http://forge.prestashop.com/browse/PSCSX-6628 - read comments https://github.com/PrestaShop/PrestaShop/commit/357a626de37f636b916e4e1b1692fe00f0fff0bc http://forge.prestashop.com/browse/PSCSX-1453 - read comments Background of the problem see following. Supply order process as below: 1)Creation in progress - OK 2)Order validated - OK 3)Pending receipt - Incorrect (Physical Qty and Usable Qty doesn't update. Real Qty updates correctly at this point) 4)Order received in part (Physical Qty and Usable Qty doesn't update. Real Qty updates but quantity shown is qty not received which is wrong) 5)Order received completely (Physical Qty and Usable Qty doesn't update. Real Qty becomes 0 which is incorrect) 6)Order canceled (Physical, Usable and Real Qty does not decrement) After 3(Pending receipt) or 4(Order received in part), front end shows product in stock and able to add to cart. But during checkout returns error that buyer can't pay because the item is not in stock even though the product is still listed as in stock at front end. In Warehouse>Insant stock status, real quantity shows correct quantity, but 0 in both physical qty and useable qty. Could be something to do with this. Also to note is that after clicking received in part, the "Real quantity" is updated reversed. For example, item A received 47pcs instead of Expected 50pcs from Supplier 1. After clicking save, in instant stock status it shows 3pcs. By right it should be 47pcs. Again, by this time under Physical Quantity it should be 47pcs (now it is 0 which is incorrect), and Usable quantity which should also be 47pcs(now it is 0 which is incorrect), assuming that Item A does not have any pending order in cart.

I have tried this patch but did not work... On 1.6.0.14

Me too facing this problem. On the verge of hiring a developer to fix this issue. The patch https://github.com/PrestaShop/PrestaShop/pull/3898/files seems to be for stock manager and not advanced stock manager where I need to add products using supply order to warehouse. Edit: Tried the patch anyways and it still didn't add products to Physical Qty and Usable Qty

I'm on 1.6.014. Will try it out as soon as I have other issues sorted out. Need this option badly too.