• Resolved hsb

    (@frogagainstthewar)


    Hi

    I have a problem with the labels generator. After order successfully made, in Collismo “labels outward/inward” fields are empty ?? I also try to manually generate outward/inward label direct from order but it’s not working too.
    How to fix it. Could you help me with this?

    This is my log:
    2020-07-16 13:31:09 – DEBUG : Label generation response
    {“method”:”LpcLabelGenerationApi::generateLabel”,”response”:{“messages”:[{“id”:”0″,”type”:”INFOS”,”messageContent”:”La requ\u00eate a \u00e9t\u00e9 trait\u00e9e avec succ\u00e8s”,”replacementValues”:[]}],”labelXmlReponse”:null,”labelResponse”:{“parcelNumber”:”6A19037560609″,”parcelNumberPartner”:”0075002116A1903756060801250S”,”pdfUrl”:”https:\/\/ws.colissimo.fr\/sls-ws\/GetLabel?parcelNumber=6A19037560609&includeCustomsDeclarations=false&x=0&y=0&signature=4512796d6ac61d895b39806f867f342e31c3c8738d72812683eaa6ddf652c468&preuveDepot=”}}}

    2020-07-16 13:31:08 – DEBUG : LpcRestApi::query
    {“url”:”https:\/\/ws.colissimo.fr\/sls-ws\/SlsServiceWSRest\/generateLabel”}

    2020-07-16 13:31:08 – DEBUG : Label generation request
    {“method”:”LpcLabelGenerationApi::generateLabel”,”payload”:{“letter”:{“service”:{“commercialName”:”*hidden*”,”depositDate”:”2020-07-17″,”productCode”:”DOM”,”returnTypeChoice”:3,”orderNumber”:”395″},”parcel”:{“weight”:”0.11″},”sender”:{“address”:{“companyName”:”**hidden*”,”firstName”:null,”lastName”:null,”line2″:”2 place de la Bourse”,”countryCode”:”FR”,”city”:”Bordeaux”,”zipCode”:”33000″,”email”:”***”},”senderParcelRef”:”395″},”addressee”:{“address”:{“companyName”:”HSB”,”firstName”:”HSB”,”lastName”:”HSB”,”line2″:”20 Rue Poissonni\u00e8re,”,”countryCode”:”FR”,”city”:”Paris”,”zipCode”:”75002″,”email”:”hiddenl”,”phoneNumber”:”555555555″}}},”contractNumber”:”**hidden*”,”fields”:{“customField”:[{“key”:”CUSER_INFO_TEXT”,”value”:”WC4.3.0;1.3.2″}]},”outputFormat”:{“x”:0,”y”:0,”outputPrintingType”:”PDF_A4_300dpi”}}}

    2020-07-16 13:30:53 – DEBUG : Label generation response
    {“method”:”LpcLabelGenerationApi::generateLabel”,”response”:{“messages”:[{“id”:”0″,”type”:”INFOS”,”messageContent”:”La requ\u00eate a \u00e9t\u00e9 trait\u00e9e avec succ\u00e8s”,”replacementValues”:[]}],”labelXmlReponse”:null,”labelResponse”:{“parcelNumber”:”8R42302080182″,”parcelNumberPartner”:null,”pdfUrl”:”https:\/\/ws.colissimo.fr\/sls-ws\/GetLabel?parcelNumber=8R42302080182&includeCustomsDeclarations=false&x=0&y=0&signature=158f690b0a88deca0d562a98ab8fa28a33c7e31f80d4103fc42a568d3854d82c”}}}

    2020-07-16 13:30:53 – DEBUG : LpcRestApi::query
    {“url”:”https:\/\/ws.colissimo.fr\/sls-ws\/SlsServiceWSRest\/generateLabel”}

    2020-07-16 13:30:53 – DEBUG : Label generation request
    {“method”:”LpcLabelGenerationApi::generateLabel”,”payload”:{“letter”:{“service”:{“depositDate”:”2020-07-17″,”orderNumber”:”395″,”productCode”:”CORE”,”returnTypeChoice”:3},”parcel”:{“weight”:”0.11″},”sender”:{“address”:{“companyName”:”HSB”,”firstName”:”HSB”,”lastName”:”HSB”,”line2″:”20 Rue Poissonni\u00e8re,”,”countryCode”:”FR”,”city”:”Paris”,”zipCode”:”75002″,”email”:”hidden”},”senderParcelRef”:”395″},”addressee”:{“address”:{“companyName”:”hidden”,”firstName”:null,”lastName”:null,”line2″:”2 place de la Bourse”,”countryCode”:”FR”,”city”:”Bordeaux”,”zipCode”:”33000″,”email”:”hidden”}}},”contractNumber”:”hidden”,”fields”:{“customField”:[{“key”:”CUSER_INFO_TEXT”,”value”:”WC4.3.0;1.3.2″}]},”outputFormat”:{“x”:0,”y”:0,”outputPrintingType”:”PDF_A4_300dpi”}}}
    2020-07-16 13:12:01 – DEBUG : Get tracking info response
    {“method”:”LpcUnifiedTrackingApi::getTrackingInfo”,”response”:{“return”:{“error”:{“code”:”0″,”message”:”OK”},”parcel”:{“codeTraffic”:”6A”,”consigneeCity”:”PARIS”,”consigneeCountry”:”FR”,”consigneeName”:”HSB”,”consigneeZipCode”:”75002″,”contractNumber”:”hidden”,”deliveryChoiceAvailable”:false,”deliveryTypeLabel”:”Colissimo Domicile – sans signature — FR (6A)”,”event”:{“code”:”PCHMQT”,”date”:”2020-07-16T15:05:07+02:00″,”deliveryChoice”:0,”displayPickupInfo”:false,”group”:1,”label”:”Votre colis est pr\u00eat \u00e0 \u00eatre exp\u00e9di\u00e9, il va \u00eatre remis \u00e0 La Poste.”,”multiplePointExist”:false,”numpos”:-1,”order”:5,”pchDate”:”2020-07-16T15:05:07+02:00″,”regateCode”:9910,”siteCity”:”ISSY LES MOULINEAUX”,”siteName”:” “,”siteZipCode”:”92130″},”eventLastCode”:”PCHMQT”,”eventLastDate”:”2020-07-16T15:05:07+02:00″,”eventLastLabel”:”Votre colis est pr\u00eat \u00e0 \u00eatre exp\u00e9di\u00e9, il va \u00eatre remis \u00e0 La Poste.”,”geographicCoverage”:”1″,”numposcol”:-1,”parcelNumber”:”6A19032572171″,”parcelReference”:”0075002116A1903257217801250″,”pchDate”:”2020-07-16T15:05:07+02:00″,”statusDelivery”:false}}}}

    2020-07-16 13:12:01 – DEBUG : Get tracking info query
    {“method”:”LpcUnifiedTrackingApi::getTrackingInfo”,”payload”:{“login”:”317143″,”parcelNumber”:”6A19032572171″,”ip”:”188.147.119.80″,”lang”:”fr_FR”,”profil”:”TRACKING_PARTNER”},”url”:”https:\/\/ws.colissimo.fr\/tracking-unified-ws\/TrackingUnifiedServiceWS?wsdl”}

    2020-07-16 13:12:01 – DEBUG : LpcUnifiedTrackingApi::updateAllStatuses updating status for
    {“orderId”:”10534″,”trackingNumber”:”6A19032572171″}

    2020-07-16 13:12:01 – DEBUG : Get tracking info response
    {“method”:”LpcUnifiedTrackingApi::getTrackingInfo”,”response”:{“return”:{“error”:{“code”:”0″,”message”:”OK”},”parcel”:{“codeTraffic”:”6A”,”consigneeCity”:”PARIS”,”consigneeCountry”:”FR”,”consigneeName”:”HSB”,”consigneeZipCode”:”75002″,”contractNumber”:”317143″,”deliveryChoiceAvailable”:false,”deliveryTypeLabel”:”Colissimo Domicile – sans signature — FR (6A)”,”event”:{“code”:”PCHMQT”,”date”:”2020-07-16T13:14:43+02:00″,”deliveryChoice”:0,”displayPickupInfo”:false,”group”:1,”label”:”Votre colis est pr\u00eat \u00e0 \u00eatre exp\u00e9di\u00e9, il va \u00eatre remis \u00e0 La Poste.”,”multiplePointExist”:false,”numpos”:-1,”order”:5,”pchDate”:”2020-07-16T13:14:43+02:00″,”regateCode”:9910,”siteCity”:”ISSY LES MOULINEAUX”,”siteName”:” “,”siteZipCode”:”92130″},”eventLastCode”:”PCHMQT”,”eventLastDate”:”2020-07-16T13:14:43+02:00″,”eventLastLabel”:”Votre colis est pr\u00eat \u00e0 \u00eatre exp\u00e9di\u00e9, il va \u00eatre remis \u00e0 La Poste.”,”geographicCoverage”:”1″,”numposcol”:-1,”parcelNumber”:”6A19040689946″,”parcelReference”:”0075002116A1904068994801250″,”pchDate”:”2020-07-16T13:14:43+02:00″,”statusDelivery”:false}}}}

    2020-07-16 13:12:01 – DEBUG : Get tracking info query
    {“method”:”LpcUnifiedTrackingApi::getTrackingInfo”,”payload”:{“login”:”317143″,”parcelNumber”:”6A19040689946″,”ip”:”188.147.119.80″,”lang”:”fr_FR”,”profil”:”TRACKING_PARTNER”},”url”:”https:\/\/ws.colissimo.fr\/tracking-unified-ws\/TrackingUnifiedServiceWS?wsdl”}

    2020-07-16 13:12:01 – DEBUG : LpcUnifiedTrackingApi::updateAllStatuses updating status for
    {“orderId”:”10531″,”trackingNumber”:”6A19040689946″}

    2020-07-16 13:12:01 – DEBUG : Get tracking info response
    {“method”:”LpcUnifiedTrackingApi::getTrackingInfo”,”response”:{“return”:{“error”:{“code”:”0″,”message”:”OK”},”parcel”:{“codeTraffic”:”6A”,”consigneeCity”:”PARIS”,”consigneeCountry”:”FR”,”consigneeName”:”HSB”,”consigneeZipCode”:”75002″,”contractNumber”:”317143″,”deliveryChoiceAvailable”:false,”deliveryTypeLabel”:”Colissimo Domicile – sans signature — FR (6A)”,”event”:{“code”:”PCHMQT”,”date”:”2020-07-16T12:48:52+02:00″,”deliveryChoice”:0,”displayPickupInfo”:false,”group”:1,”label”:”Votre colis est pr\u00eat \u00e0 \u00eatre exp\u00e9di\u00e9, il va \u00eatre remis \u00e0 La Poste.”,”multiplePointExist”:false,”numpos”:-1,”order”:5,”pchDate”:”2020-07-16T12:48:52+02:00″,”regateCode”:9910,”siteCity”:”ISSY LES MOULINEAUX”,”siteName”:” “,”siteZipCode”:”92130″},”eventLastCode”:”PCHMQT”,”eventLastDate”:”2020-07-16T12:48:52+02:00″,”eventLastLabel”:”Votre colis est pr\u00eat \u00e0 \u00eatre exp\u00e9di\u00e9, il va \u00eatre remis \u00e0 La Poste.”,”geographicCoverage”:”1″,”numposcol”:-1,”parcelNumber”:”6A19032528512″,”parcelReference”:”0075002116A1903252851801250″,”pchDate”:”2020-07-16T12:48:52+02:00″,”statusDelivery”:false}}}}

    2020-07-16 13:12:01 – DEBUG : Get tracking info query
    {“method”:”LpcUnifiedTrackingApi::getTrackingInfo”,”payload”:{“login”:”*****”,”parcelNumber”:”6A19032528512″,”ip”:”188.147.119.80″,”lang”:”fr_FR”,”profil”:”TRACKING_PARTNER”},”url”:”https:\/\/ws.colissimo.fr\/tracking-unified-ws\/TrackingUnifiedServiceWS?wsdl”}

    2020-07-16 13:12:01 – DEBUG : LpcUnifiedTrackingApi::updateAllStatuses updating status for
    {“orderId”:”10530″,”trackingNumber”:”6A19032528512″}

    Best Regard
    Rafael

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Colissimo

    (@iscpcolissimo)

    Hello,

    i think two tables are missing in you database.

    Can you create the following tables:

    CREATE TABLE bdd_lpc_outward_label (
    id INT UNSIGNED NOT NULL AUTO_INCREMENT,
    order_id BIGINT(20) UNSIGNED NOT NULL,
    label MEDIUMBLOB NULL,
    label_format VARCHAR(255) NULL,
    label_created_at DATETIME NULL,
    cn23 MEDIUMBLOB NULL,
    tracking_number VARCHAR(255) NULL,
    PRIMARY KEY (id),
    INDEX order_id (order_id),
    INDEX tracking_number (tracking_number)
    ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
    ) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

    CREATE TABLE bdd_lpc_inward_label (
    id INT UNSIGNED NOT NULL AUTO_INCREMENT,
    order_id BIGINT(20) UNSIGNED NOT NULL,
    label MEDIUMBLOB NULL,
    label_format VARCHAR(255) NULL,
    label_created_at DATETIME NULL,
    cn23 MEDIUMBLOB NULL,
    tracking_number VARCHAR(255) NULL,
    outward_tracking_number VARCHAR(255) NULL,
    PRIMARY KEY (id),
    INDEX order_id (order_id),
    INDEX tracking_number (tracking_number),
    INDEX outward_tracking_number (outward_tracking_number)
    ) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

    bdd is the scheme where you create the two tables.

    Best regards

    Plugin Author Colissimo

    (@iscpcolissimo)

    sorry for the first table the first default is to be deleted.

    best regards

    Thread Starter hsb

    (@frogagainstthewar)

    Hi

    This is it!
    It’s working now.
    Thank you very much.

    Best regards

    Plugin Author Colissimo

    (@iscpcolissimo)

    Hi

    you’re welcome.

    Best regards

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Labels generate problem’ is closed to new replies.