longy

For example in my catalog there are: - ipod 8gb red - ipod 8gb blue - ipod 16gb So i don't have color attribute for 16gb version of ipod. In the product page, when i select 16gb, color selector doesn't disappear. Users are also allowed to add to cart the unavailable combination. Into cart detail color is omitted, but it's confusing for the customer. I also tried to disable under Settings>Product the option 'Show unavailable attribute in product page'. Any way to hide unavailable attributes, or avoid to put them in cart? Thanks in advance for replies.

up

Prestashop 1.6.

I need a module that allow to export/import products, categories and combinations in/from csv(or sql), with the capabilities to: split csv each n rows; csv format fully compatible with prestashop importer; set id to a specific offset (positive or negative) to avoid collision with pre-existing products; use as univocal combination_id and product_id allowing combination update from importer. The inability to actually import a catalog is a great lack of prestashop. Does exist something similar?

up

Prefix change is applied to invoice of 2014 too, and it's wrong.

From the start of 2015 the invoice number continue from last number in 2014. I cannot solve just restarting manully "order_invoice" table setting "number" and "delivery_number" fields. In database, yesterday, last invoice (1st for 2015) has number and delivery number set to 1. Today I've 2 new orders, number and delivery number are wrong. They are greater than max number and delivery_number ignoring year.

I've also tried a similar approach. Selecting all tables and columns having column names like %product%. In this way I'll get also table like order_details and accessory that doesn't present substring 'product' in their name, but contain columns with that substring. I had momentarily set aside this approach in the hope of finding some specific resource to accomplish at this task. However thanks to your information, now I know it's almost the best approach.

Thanks for reply tungCEO, I'll explain all that I tried. Initially I checked for constraints using following query: select TABLE_NAME t, COLUMN_NAME c from information_schema.KEY_COLUMN_USAGE where TABLE_SCHEMA = "dbname" and REFERENCED_TABLE_NAME = "ps_product" and REFERENCED_COLUMN_NAME = "id_product" group by t, c It returns 0 results. Because for some reason prestashop, at least in my case, did not define any constraints. Then I downloaded the er scheme, open on mysql workbench and I can see a lot of arrow representing relations. So I exported model to sql and import in a new empty database. This operation generate some errors but database is created and there are some constraints but I don't think that they are all. Launching the previous query I get just 29 results and I can't see some obvious foreign key and table name such as id_product_1 and id_product_2 for ps_accessory table. I don't think that it's possible to get all information needed in less then a week reading manually all tables from database schema. And from my last try I don't think that database schema is free from errors or omissions

I need to change all id_product value in ps_product table, and adjust accordingly all fields that refer to it. I need all tables and foreign keys that refer to ps_product.id_product. Could someone list me every relation with this field?

up

I need to add some simple javascript to back office footer via module. I've already built the module and it works pretty good on backoffice, I'm using displayBackOfficeFooter hook but it's not applied to login page. I don't want to modify login page tpl directly, but I can't find any display hook related to back office login page. Can someone helps me? Thanks in advance.

I would know how to apply discount based simultaneously on: - carrier; - payment type; For example: - retirement from office AND cash on retirement (delivery) 15% - retirement from office AND deferred payment 10%

You're right second image simply appears over first. It's only a matter of transparency.

I'm not using default-bootstrap theme. Product inserted when I was using default-bootstrap theme don't have the problem. All products inserted after new theme installation are affected by this issue. Is there a module that manage this effect?