Jump to content


  • Posts

  • Joined

  • Last visited

Everything posted by newcomer

  1. Bernad77 version has worked the best so far. Thanks dude for your contributions.
  2. 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.
  3. Also having the same problem. Has this been fixed that we aren't aware of?
  4. 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?
  5. 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?
  6. 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?
  7. 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.
  8. 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?
  9. 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
  10. Follow this link to download the patch search.php to replace the one in your /classes folder. It works for me. Am on https://www.prestashop.com/forums/topic/509403-problem-in-indexing-rebuilding-search/?p=2269424
  11. 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
  12. 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.
  13. Can I replace the stock tpl files with this module instead? Don't want to redo my styles... As for the 0 at main category, I guess in product association page you can try to associate it with the main category as well other than its sub? I would like to know if the product counter is cached? Don't want to it to run everytime user goes to a new page.
  14. Having this issue too. Do you mind sending the developer contact to me too?
  15. How do turn off thumbnail generation during import csv?
  16. 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.
  17. For the null method to shop_id, you need to enable the NULL option under the "Structure" tab.
  18. 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.
  19. 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?
  20. After trying it for a bit, these are my findings: 1)POS does not support salesperson management, instead it treats the staff(whoever is making sales) as a "customer". This is no different from creating new orders at BO on behalf of customers. POS is supposed to handle walk-ins right? If "customer" must be filled then the payment process will be slow and painful for staffs as they have to create a new customer profile just to complete the POS. Most customers are one off. 2)Offline bug (duplicate entries). For real time update of qty and orders ID, one has to enable Direction Connection/HTTP Tunnel. IMHO this would cripple the offline capability of Store Manager. On top of that, Store Manager would require stable uninterrupted internet connection. The solution can be; Store Manager does not assign an Order ID UNTIL the offline data has been posted to web. Or, Store Manager may automatically reassign any unused ID to orders created offline when it detects an Order ID has been issued online. 3)Missing features in POS window. QTY available, Order message (editable), multiple partial payment received, etc. 4)Associating warehouses to staffs (For POS salesperson). As a software that sells multiple licenses packages to clients that have multiple stores, this is a must have feature. Scenario: Staffs - Staff A, B, C Warehouse - W1, W2 Staff A and Staff B works at W1 and W2 on a biweekly rotation basis. When Staff A is working at W1, any POS sales made by Staff A should result in QTY decremented from W1, and W2 if he were working at W2. This holds true for Staff B conversely. Staff C only works at W2 and would therefore be only associated to W2. Currently Store Manager deducts stock from whichever warehouse PS tells it to. This is bad behavior and should be corrected by Store Manager ($349 software).
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More