Jump to content

Falgener

Members
  • Posts

    63
  • Joined

  • Last visited

Posts posted by Falgener

  1. 26 minutes ago, Tim Riley said:

    Hi,

    I have downloaded price mass edit discounts. 

    Apply All Discounts has no effect (when product has many combinations) but works fine for small number of combinations per product.

    I can not reduce items per page as there is only 1 product on page with about 500 combinations.

    Can you reccomend a solution please?

    Hi,

    thanks for download.

     - this can happen, if is exceed php_value post_max_size or max_input_vars limit or max_execution_time limit.
    If you can, increase this values on your server.
    In other case try  decrease "Items per page" in module.

    I will contact you via PM with more info ...

     

  2. 7 hours ago, LIONEL said:

    Hi,

     

    OK It works. Thanks.

    Just a last question, i would like to add the private note for the customer in my export.
    I don't find this field. How do i add this field?

    Regards,

    Lionel

     

    Hi,
    I have added this field yesterday, because seems to be useful for other users.
    So download latest version from your account - orders history /  detail -  see http://www.praotec.com/nvn-modules-update/
    Thanks

  3. Hi,
    yes, it is possible, but not as user defined xml, but with xslt transform. Switch to export as xml and define xslt.
    see this article:
     
    for example:
    <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
      <xsl:output omit-xml-declaration="yes" indent="yes" method="xml" version="1.0" />
        <xsl:key use="order_id" match="/nvn_export_orders/order" name="groups"/>
      <xsl:template match="/">
        <xsl:apply-templates select="/nvn_export_orders" />
      </xsl:template>
      <xsl:template match="/nvn_export_orders">
        <OrdersOut>
          <xsl:for-each select="order[generate-id(.)=generate-id(key('groups',order_id))]">
            <OrderSummary>
              <OrderId>
                <xsl:value-of select="order_id/text()" />
              </OrderId>
              <Orderdate>
                <xsl:value-of select="date_add/text()" />
              </Orderdate>
              <Items>
                  <xsl:for-each select="key('groups',order_id)">
                    <ItemName>
                      <xsl:value-of select="product_name/text()" />
                    </ItemName>
                    <ItemQuantity>
                      <xsl:value-of select="product_quantity/text()" />
                    </ItemQuantity>            
                  </xsl:for-each>      
              </Items>
            </OrderSummary>
          </xsl:for-each>
        </OrdersOut>
      </xsl:template>
    </xsl:stylesheet>
     
     
     
     
     
  4. Hi

     

    Module: 2.7.4

     

    We are using  "XML transformation - XSLT stylesheet"

     

    In prestashop we have some long product references so I have modified the field lengths in the tables and some PHP files

     

    Max field length is normally 32 characters for product reference, we have increased to 64 charachters

     

    When we export the orders, it seems the module is still only 32 characters, so this code: "CLAMP/T304/38-40*6-36-100-20-12-3" is exported as "CLAMP/T304/38-40*6-36-100-20-12-"

     

    Is there somewhere in the module files that limit this to 32 characters? Can you point me to where so I can increase it?

     

     

    Hi,

    no, module don't check fields length, used same length as in database.

    But maybe your modification use different (new) field...

     

    Note that module use product reference field from ps_order_detail table.

    You can try use product reference field from ps_product table.

    At the end of module are defined fields.

    Try change this:

     

    array('od.product_reference AS product_reference',                     $this->l('Product Reference'),          51,1,0,3,0),

     

    to

     

    array('pr.reference AS product_reference',                     $this->l('Product Reference'),          51,1,0,3,0),

  5. Thanks

     

    I will try the update process (Export settings etc) and let you know if it fixes the issue.

     

    I assume that I first delete the module and then install it completely and then import the settings?

     

    Cheers

    Greg

     

    yes (delete is not required, because all files are overwritten when upload new version), but uninstall / install is required.

  6. Hi

     

    Are those 2 functions your functions or standard Prestashop functions?

     

     

    My shopping cart functionality has been modified slightly so i am interested to know at what point eg: when the payment button is clicked, does your code/function kick in?

     

    Cheers

    Greg

    Hi,

    this are my functions, but similar are used in prestashop for example for sending notification about new order.

     

    But what can be problem: module need register two hook.

    This is activated in installation process.

    So if You used old version before, You need export settings, uninstall old and then install new version and import settings. ( http://www.praotec.com/nvn-export-orders-update/ )

  7. Hi again,

     

    I am having trouble getting the Live Export to work...

     

    Can you please answer the following questions?:

     

    1. is any Prestashop code changed/modified? If so, what and how?

    2. what part of the Checkout process actually triggers the export?

     

    Thanks

    Greg

     

    Hi,

    no Prestashop code modified.

    Live export is solved in this two functions:

    function hookNewOrder($params)

    function hookFooter($params)

    Note: setting for "Iive export" must be active setting.

  8. Hi Falgener,

     

    Thanks for the quick reply!

     

    Currently, I have Export Order configured to export ALL orders via the Cron task.....if I activate (turn on) the "Live Export" option will it also export ALL orders each time a new Order is created and create the file exactly like it does via the Cron Task????

     

    Thanks

    Greg

     

    Yes, "Live export" use all setting, filters etc... like "normal" export. Only switch to any setting,  select live export and save. Module must remain  switched on this setting.

  9. Hi Falgener

     

    Firstly, I have been using your module for a long time  and it is really great!

     

    Currently, I have it configured via a Cron Task to automatically run at preset times and this works well..I also "manually" trigger the Cron task to run it on demand.

     

    I am looking for a way to eliminate the automatic Cron task and would like to know if there is a way to "trigger" the export to happen whenever a shopping cart is finalised?

     

    Thanks again for a great module....

     

    Cheers

    Greg

     

    Hi,

    and thanks.

    Yes, this is possible with "Live export". See image:   https://prnt.sc/fdafgu    SETTING: Live export.

    But remember that this setting  works only for currently active setting.

  10. 1/

     

    Thank you !
    About question 1, the goal is to count the number of order_detail lines. Is it possible ?

     

    And similarly, i would like to summarize the total weight of order, i have tried to play with groups and calculated field but i did not succeed.

     

     

    About question 2, your solution should work well :)

     

    One more thing, is it possible to include the customer message about the delivery in the XML output ?

     

    Many thanks

     

    1/

    add into xslt lines: 7 (var "set"), 8(var"count"), row 12 is <TOTAL_ITEMS>

    <?xml version="1.0" encoding="UTF-8"?>
    <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
    <xsl:output omit-xml-declaration="no" indent="yes" method="xml" version="1.0" encoding="UTF-8" />
    <xsl:key use="order_id" match="/nvn_export_orders/order" name="groups"/>
    <xsl:template match="/"><xsl:apply-templates select="/nvn_export_orders" /></xsl:template>
    <xsl:template match="/nvn_export_orders">
    <xsl:variable name="set" select="/nvn_export_orders/order" />
    <xsl:variable name="count" select="count($set)" />
    
    <!-- FIRST ROW AND WRAPPER-->
    <commandes xmlns:od="http://www.w3.org/2001/XMLSchema-instance">
    <TOTAL_ITEMS><xsl:value-of select="$count" /></TOTAL_ITEMS>
          <xsl:for-each select="order[generate-id(.)=generate-id(key('groups',order_id))]"><!--ORDER CYCLE-->
          <CC_ENTETE>
             <!--COMMON VALUES HERE-->
              .....
              .....
    

    2/ it is not possible with "Group by", because whole order is summarized into one row. This is possible with module extension.

     

    3/ add field "Customer message" into  exported fields and into xslt for example

    <CUST_MESSAGE><xsl:value-of select="message" /></CUST_MESSAGE>

  11. Hi,

     

    I have 2 questions :

    1) How can i add the number of order_detail lines in the XML output ?

    2) For each <order_detail>, i would like to increment a value : 1, then 2, then 3, is it possible ?

     

    Many thanks

     

    Hi,

    1/ Add field "Order Detail ID" into exported fields.

    In user defined xml will be something like <id_order_detail>#id_order_detail#</id_order_detail>

    In xslt <id_order_detail><xsl:value-of select="id_order_detail" /></id_order_detail>

     

     

    2/In xslt?

    use position() inside for-each

    for example:

    <xsl:for-each select="key('groups',order_id)"><!--ITEM CYCLE-->
                      <!--ROWS ITEMS HERE-->
                      <CC_LIGNE>
                                <DEPOSANT>XXX</DEPOSANT>
                                <SHOP>YYY</SHOP>
                                <SITE>0</SITE>
                                <ROW><xsl:value-of select="position()"/></ROW>
                              .....
                              .....
                      </CC_LIGNE>
                      </xsl:for-each><!--ITEM CYCLE END-->
    
    • Like 1
  12.  

    Hello there, We want to buy your order export plugin. We need to esport orders in XML format to import them into the S3 money system after that. Before we buy your plugin, we wanted to ask you if is possible modificate xml export by this file https://drive.google.com/open?id=0B1EiX486ALM0QkdXb2lIRFFOTms . thats right format example how it should be.
     
    So is it possible?
     
    In case we will need help and assist with something to reach that format, can we contact you directly?
     
    Thanks 
     
    Michal.

     

     

    Hello,

    yes, it is possible, but I must prepare module extension for this specific XML.

  13.  

    It seems to export ALL orders when there are no new ones.

     

    We do still get this message:

     

    Sorry, but there are NO NEW orders to export with this filters and options setting.
     
    But the file is not empty it contains all orders

     

     

    You are right, this is my bug :( .  Will be fixed, wait a moment.

  14.  

    It seems to export ALL orders when there are no new ones.

     

    We do still get this message:

     

    Sorry, but there are NO NEW orders to export with this filters and options setting.
     
    But rhe file is not empty it contains all orders
     
    I did just install over the top. Should I have uninstalled first perhaps?

     

     

    No, don't uninstall, only overwrite old version and save new settings.

    I must check it, I tested with FILTERS "Last Exported Order ID" and empty file is exported (only columns names ).

    Yes, message is still  generated.

  15. Is there a setting (or a code change) I can use so that the export file is created even when there are no new data?

     

    When there is no data i get:

    Sorry, but there are NO NEW orders to export with this filters and options setting.

    But it would be really useful just to create the file with the column headings

     

    Hi,

    yes, it is possible and simple with small code change. Wait a moment, I need test it and will send instruction "how to"

    • Like 1
×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More