Para crear un ticket de soporte, comience con una búsqueda


Tables used in queries


Database fields that you add are used in queries already calling some tables in the database

Below is the list of tables used by grid, and you can use the aliases provided.

Product grid

Table Alias
product
p
product_lang
pl
image
i
If Prestashop version is >= 1.5
product_supplier
ps
stock_available
sa
supplier_shop
ss
product_shop
prs

Combination grid

Table Alias
product
p
product_attribute
pa
product_attribute_combination
pac
attribute
a
attribute_group
ag
attribute_lang
al
attribute_group_lang
agl
If Prestashop version is >= 1.5
product_shop
p_shop
product_attribute_shop
pa_shop
product_supplier
ps
stock_available
sa

Multi-Store Combination grid

Table Alias
product_attribute
pa
product_attribute_shop
pas

Order grid

Table Alias
orders
o
order_history
oh
message
(if Message column is used)
m
order_detail
(if In Stock column is used)
od
customer
c
address
(shipping address)
ad
address
(invoice address)
adi
storecom_delivery_info
((if SC Delivery Dates add-on is installed)
sdi

Customer grid

Table Alias
customer
c
address
(if id_address is present in the grid)
a