Wilfredcy
Members-
Posts
29 -
Joined
-
Last visited
Profile Information
-
First Name
Banana
-
Last Name
Guy
Recent Profile Visitors
292 profile views
Wilfredcy's Achievements
Newbie (1/14)
0
Reputation
-
I found one order has a incorrect total price, in the order detail the products section showing the wrong price RM 8.02 (see image order price.jpg), it doesn't make sense because all the product sum up is RM 32. But in the invoice the total price is correct. So I would like to know what going on and how can I fix it? Other orders is fine, just this particular order.
-
How to export order's full address in SQL manager?
Wilfredcy replied to Wilfredcy's topic in General topics
Hi, any help? -
I create a SQL query in the SQL manager for export order details, but I found out that the order address is not complete for some order. (see attachment 1). Then I realize if the user inserts their address with a comma, the address is going to be not complete when exporting. example: "123 Taman Good Jalan Hill 12345 Tawau" will result in "123 Taman Good Jalan Hill 12345 Tawau" in the csv file. But if "123 Taman, Good Jalan Hill, 12345, Tawau", it will result in "123 Taman" in the CSV file. It is because of the comma. How can I fix that? SELECT d.id_order, o.reference, o.total_discounts_tax_incl, o.total_shipping_tax_incl, os.name AS state, d.product_name, d.product_reference, d.product_price, d.product_price - d.reduction_amount AS final_price, d.product_quantity, o.payment, o.date_upd, g.email, g.birthday, address.phone, address.phone_mobile, CONCAT_WS(' ', g.firstname, g.lastname) AS customer, CONCAT_WS(' ',address.`address1`,address.`address2`, address.`postcode`, address.`city`, statelocation.`name`) AS `address`, carrier.name, sp.price FROM ps_order_detail d LEFT JOIN ps_orders o ON (d.id_order= o.id_order) LEFT JOIN ps_customer g ON (o.id_customer = g.id_customer) LEFT JOIN ps_group_lang gl ON (g.id_default_group = gl.id_group) AND gl.name LIKE 'club%' LEFT JOIN ps_order_state_lang os ON (o.current_state = os.id_order_state) LEFT JOIN `ps_address` address ON (o.id_address_delivery = address.id_address) LEFT JOIN ps_carrier carrier ON (o.id_carrier = carrier.id_carrier ) LEFT JOIN ps_state statelocation ON (address.id_state = statelocation.id_state) LEFT JOIN ps_product oproduct ON (d.product_id= oproduct.id_product ) LEFT JOIN ps_message me ON (o.id_order = me.id_order) LEFT JOIN ps_product_shop sp ON (oproduct.id_product = sp.id_product) WHERE os.id_lang = 1 ORDER BY d.`id_order` DESC
-
I want to export the order source data via the SQL manager, but I have no idea where the section located in the database. Does anyone know about this?
-
Duplicated list of product list, and how to fix it.
Wilfredcy replied to Wilfredcy's topic in General topics
Hi, it work, THANK YOU The code: SELECT a.`id_product`, b.`name`, a.`reference`AS `main_sku`, pa.`reference` AS `sku`, b.`link_rewrite` AS `url`, a.`price` AS `price`, sav.`quantity`, m.`name` AS `Manufacturer` FROM `ps_product` a LEFT JOIN `ps_product_lang` b ON ((b.`id_product` = a.`id_product`) AND (b.id_lang = "1")) LEFT JOIN `ps_manufacturer` m ON (a.id_manufacturer = m.id_manufacturer) LEFT JOIN `ps_product_attribute` pa ON (pa.`id_product` = a.`id_product`) LEFT JOIN `ps_stock_available` sav ON ((sav.`id_product` = a.`id_product`) AND (coalesce(sav.id_product_attribute,0) = 0 OR (pa.id_product_attribute is null)) OR (pa.id_product_attribute = sav.id_product_attribute)) WHERE 1 ORDER BY a.`id_product` ASC -
Duplicated list of product list, and how to fix it.
Wilfredcy replied to Wilfredcy's topic in General topics
Hi, I using the code above now it exports empty. -
Duplicated list of product list, and how to fix it.
Wilfredcy replied to Wilfredcy's topic in General topics
Hi, it show the quantity for the product with no combination, but now the product with the combination is duplicated again. -
Duplicated list of product list, and how to fix it.
Wilfredcy replied to Wilfredcy's topic in General topics
Hi, sorry to bother you again. I just realize that there got another problem, which is the product with no combination cannot show its quantity, how can I fix this? -
I am facing this issue, it happens few time. Anyone got tha solution
-
Wrong link_rewrite format but still can be POST
Wilfredcy replied to Wilfredcy's topic in General topics
Anyone? -
I encountered an error the Friendly URL, as if link_rewrite input is "abc.com" , Prestashop allows to create the product instead of giving an error as "invalid field value" for friendly URL. Below is the request's body for the same for which I use the post method to create the product: Request: <?xml version='1.0' encoding='UTF-8'?> <prestashop> <product> <id_supplier>3</id_supplier> <id_manufacturer>3</id_manufacturer> <id_tax_rules_group>1</id_tax_rules_group> <width>10</width> <height>10</height> <depth>10</depth> <weight>10</weight> <id_category_default/> <id_shop_default>1</id_shop_default> <on_sale>1</on_sale> <ean13>1234567</ean13> <upc/> <price>889.38</price> <wholesale_price/> <ecotax/> <unit_price_ratio/> <unity/> <reference>Leather Bag Collection</reference> <active>1</active> <available_for_order>1</available_for_order> <condition>new</condition> <visibility>both</visibility> <show_price>1</show_price> <online_only>0</online_only> <name> <language id='1'>Leather Bag Collection</language> </name> <description> <language id='1'>Leather Bag Collection</language> </description> <description_short> <language id='1'>Short Desc</language> </description_short> <link_rewrite> <language id='1'>xyz.com</language> </link_rewrite> <meta_title> <language id='1'>Meta</language> </meta_title> <meta_description> <language id='1'>Meta</language> </meta_description> <meta_keywords> <language id='1'>Meta</language> </meta_keywords> <associations> <tags> <tag> <id>106</id> </tag> <tag> <id>28</id> </tag> <tag> <id>297</id> </tag> </tags> <categories> <category> <id>24</id> </category> </categories> </associations> </product> </prestashop> Response: Product created successfully. Expected: Product shouldn't be created.