buzzworm

Hi, I'm running PS 1.6.1.7, without Advanced Stock Management. I'm trying to clean up and recover after a failed attempt to enable Advanced Stock Management so that I can try again later. I seem to have bad entries in my ps_warehouse table and am not sure if I should manually delete them from the database, since I can't delete them using the back-office. Background: I tried connecting a Point-Of-Sale program that integrates with Prestashop. This program automatically enabled Advanced Stock Management. However, once it was enabled, all my stock was 0 and "unavailable" on my site. It was a "panic" situation and I quickly disabled Advanced Stock Management. I remember having to manually restore quantity to our products after turned it off. I don't remember the exact sequence of events but after a couple failed attempts to get the POS program working with Advanced Stock Management, I was left with three warehouses in the database. However, two appeared to have incomplete data. I was unable to delete the incomplete warehouses because Prestashop would give me an error, something like "cannot delete warehouse". I exported my database from phpMyAdmin into a SQL file and here's what it has for the ps_warehouse table: INSERT INTO `ps_warehouse` (`id_warehouse`, `id_currency`, `id_address`, `id_employee`, `reference`, `name`, `management_type`, `deleted`) VALUES (1, 1, 929, 1, 'WAREHOUSE-1', 'Warehouse 1', 'WA', 1), (2, 1, 0, 0, NULL, 'Warehouse 1', 'WA', 0), (3, 1, 0, 0, NULL, 'Warehouse 1', 'WA', 0); I'm afraid to delete the "bad" records for fear of causing other database problems. So I created a test instance of my store to test my data cleanup plans, and imported the database export file into my test Prestashop store. However, after import, only one warehouse row was created, and the data is different from the file that I imported: INSERT INTO `ps_warehouse` (`id_warehouse`, `id_currency`, `id_address`, `id_employee`, `reference`, `name`, `management_type`, `deleted`) VALUES (1, 1, 5, 1, 'Warehouse 1', 'Warehouse 1', 'WA', 1); Now I'm confused! 1) I thought that exporting my database, and importing into my test database, would yield and exact copy of my data in my test store, but it didn't 2) Now I'm unable to test deleting the bad warehouses My ultimate goal is to "practice" setting up and using Advanced Stock Management on my test instance so that I can confidently get it working on my production store. Thanks for any help!

Is turning on allow_url_fopen a security risk? Googling this setting led me to believe that it's risky. My only purpose for turning it on would be to fully enable the AdminModules panel for Prestashop Addons. Here's what my hosting provider (A2 Hosting) had to say about it: The allow_url_fopen directive is disabled by default. You should be aware of the security implications of enabling the allow_url_fopendirective. PHP scripts that can access remote files are potentially vulnerable to arbitrary code injection.

I'm very confused by partial refunds and credit slips. I did a partial refund for $5.50 for the customer's shipping cost, but no refund was sent to the card. I logged into my Authorize.net account and verified that there's no indication of a $5.50 refund. So I had to manually refund $5.50 from my Authorize.net account, outside of PrestaShop. But of course the customer still has a credit slip for $5.50. The customer will be able to use this for a $5.50 discount in the future, right? Of course I don't want that since I gave a refund. Is there any way to refund the customer instead of creating a credit slip? I've read the documentation I could find and there's not much explanation about doing credit card refunds, but only that a credit slip is always created. Thanks!

Is there any way to delete a credit slip in 1.6? I don't see a way. I didn't realize that partial refunds generated credit slips instead of refunding the credit card. So I want to delete the credit slip so I can refund the card by another means outside of PrestaShop. thanks

Is there no way to delete a credit slip and re-issue the partial refund?

Hi Vekia, (or anyone else who cares to chime in), Do you still feel that having a separate blog installation like Wordpress is superior to installing a blog module? I found this on the forum which looks interesting: https://www.prestashop.com/forums/topic/432988-free-module-wordpress-blog-integration-to-prestashop-13141516/?hl=+wordpress%20+module thanks, glen

Hi, I'm using 1.6.0.9 and I noticed the following problem with the csv export feature: (note: sensitive info replaced with xxxxx's) 1) When exporting customers, extra html and apparently linebreaks are included on the data lines which screws up the csv file e.g., "516","","xxxxxxx","xxxxxx","[email protected]","","1","<a class="list-action-enable action-enabled" href="index.php?tab=AdminCustomers&id_customer=516&changeNewsletterVal&token=xxxxxxxxxxxxxx"> <i class="icon-check"></i></a>","<a class="list-action-enable action-enabled" href="index.php?tab=AdminCustomers&id_customer=516&changeOptinVal&token=xxxxxxxxxxxxxx"> <i class="icon-check"></i></a>","2014-09-01 19:54:22","2014-09-02 16:03:58", 2) When exporting orders, no page is loaded at all. For example, Firefox shows this error: This webpage is not availableLess The webpage at http://www.yorkshireyarns.com/adminxxxx/index.php?controller=AdminOrders&exportorder&token=xxxxxxxxxxxxxx might be temporarily down or it may have moved permanently to a new web address. Error code: ERR_INVALID_RESPONSE

Hello, I'm seeing this in 1.6.0.8 but I believe I remember seeing this in earlier versions also. Browser: Chrome Version 35.0.1916.153 m Repro: Catalog > Attributes and Values > View (for one of the attributes in the list) (The list of values is displayed) Select one or more values by clicking the checkbox on the left. then click: Bulk Actions > Delete Selected The error message "You must select at least one element to delete." is displayed and the values are not deleted.

YES! That fixed it. Thank you! HTML Purifier, I don't need your services!

Hi, I made these changes but am having trouble with my HTML changing after saving. I am trying to save the embed code for my Google calendar, which worked fine on my old site: <p><iframe src="https://www.google.com/calendar/embed?height=600&wkst=1&bgcolor=%23ffcc66&src=yorkieteam%40gmail.com&color=%232952A3&ctz=America%2FLos_Angeles" width="805" height="600" frameborder="0"></iframe></p> I select "source code" and paste in the above code snippet, then save. I see a big "?" image in the preview window then re-select "source code". However, it is being changed to this: <p><iframe width="300" height="150" src="%5C"></iframe></p> Any ideas why this is happening? thanks!

I had the same issue while testing a cart rule I created in 1.6.0.6. I could not find any problem with its configuration. I deleted it and re-created it and it worked fine. I'm guessing its configuration somehow became corrupted in the database when I was setting it up.

Hi everybody, I would like to leave the birthday month and day on the "Create an Account" page, but remove the year. I've commented out the year already on the three forms authentication.tpl order-opc-new-account.tpl identity.tpl but get "invalid date of birth" when saving a month & day, because of the blank year. I don't want to ask customers their age by asking for the year, but would like to retain the the month & day for birthday marketing purposes. Any hints on how to remove the year without removing the birthday month and day? Possibly defaulting to some value "under-the-hood"? I'm using 1.6.0.6 thanks

I had the same experience today after upgrading to 1.6.0.6 with the two Contact Information block modules. It would not save any data. Thankfully I found the trick in this thread of uninstalling the contact info modules, then reinstalling. Now it works! thanks!

Hi, I'm planning on using PrestaShop to sell products in our physical store in addition to online sales. I'm evaluating using the "Create Order" feature in the back office to sell in-store. However I'm not sure about the best way to take credit card payments in our physical store when selling through the back office when the customer is standing there It has to be fairly quick and efficient.. Currently we have a standalone Verifone credit card terminal in our store. So these options come to mind: 1) Create a "card in store" payment module that's only visible in the back office, just to mark the order "paid by credit or debit card". The payment would actually be made through the Verifone terminal. 2) Click the "go to payment page to process the payment" button and manually enter the card number just as if the customer was placing an online order, and complete the order this way. However the customer couldn't use a credit/debit card as debit, because there's no PIN pad. 3) Same as #2 above but use a magnetic stripe reader to automatically fill out the credit card fields (is this possible?), then complete the order. Also, the customer couldn't use a credit/debit card as debit, because there's no PIN pad. Any help or advice would be greatly appreciated! thanks

Hi everybody, what I'm looking for seems simple but after a couple hours of research I can't find the answer. I want to use PrestaShop's back office "create order" feature to sell products in our physical store (in addition to online). So for the in-store sales, I want to be able to mark orders as paid by cash, check, or credit card (in-store, processed via terminal) but not show these options for the online customers. They need to be visible in the back-office "create order" page only. Online customers will only use the standard online payment options of credit card (i.e. Authorize.net) or PayPal. e.g. when I enable the Check module, it appears in both the front-office and back-office but I only want it to appear in the back office. I supposed if I can get that figured out, I can duplicate it for the other modules I need (cash, in-store cards). I'm thinking it may be related to hooks but I'm just learning about them. I see the hookPayment and hookPaymentReturn functions in cheque.php but I'm not sure if it's possible to specify front vs. back office or if I'm barking up the wrong tree altogether. Thanks for any advice!