Jump to content

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

Newbie (1/14)

0

Reputation

  1. 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.
  2. Just want to know any other forum that can help for Prestashop issue, someplace like Stack Overflow.
  3. I already asked a few questions in this forum, but most of the time I got no answer, seems like this forum is no active.
  4. 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
  5. 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?
  6. I have one particular product that needs to show on that section no matter what the product the user order. Is there any module or setting can do this? Or how can I edit its PHP file?
  7. 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
  8. Hi, it show the quantity for the product with no combination, but now the product with the combination is duplicated again.
  9. 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?
  10. I am facing this issue, it happens few time. Anyone got tha solution
  11. 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.
×
×
  • Create New...