How to configure promotional SKUs

Modified on Tue, 18 Feb at 9:34 AM

TABLE OF CONTENTS


OVERVIEW


This article focuses on adding promotional (temporary) items to specific orders based on conditions. 

Such items will be added to orders processed through Techdinamics IntegratedFlow system and will be uploaded as part of these orders to a target system/WMS. Once orders are processed in the target system/WMS, promotional items will be removed from them not to affect the source system.


ADDING PROMOTION RULES


Once you are logged in to the Techdinamics Customer Portal, proceed to the Integrated Flow section in the menu on the left side of page. Select Cross References tab with the list of all tables you have access to. In this case you need to click PROMOTIONS. 


Ensure that that SENDER and RECEIVER contain correct Customer name and source system. If required, select different customer and system.


You can add promotion rules values manually or using excel template. 


CREATE A SINGLE RULE


  1. To add values manually, click the "CREATE" button.



  2. Populate the pop-up window with valid data, using instructions provided below


 

  • Table Name is PROMOTIONS
  • SenderCode contains one or multiple conditions. Use delimiter | without blanks to split multiple conditions.
    Use one or combination of the following conditions for SenderCode:
    • All – will work for all orders
    • contains:SKU will check if order contains a certain SKU
    • reference:qualifier=value will check if reference with the mentioned qualifier is equal to the value*
      *Using reference, you can check a field’s value from the source system, for example order count for the certain customer, or any other field defined by/for the integration. If you don’t know the needed reference qualifier, request integration or support team to provide you with this. Please note that if a new logic has to be built in order to support specific conditions, CR process may be initiated.
  • ReceiverCode contains one or multiple SKUs to be added to orders that meet conditions
  • Value1 contains start date and time when promotion rule should start to work (mandatory), and end date and time (conditional) separated with delimiter |
  • This field should have a format of YYYYMMDDHHmmss|YYYYMMDDHHmmss or YYYYMMDDHHmmss|  
  • Value2 could be used as Promotion Rule Id (conditional)


Once the record is created, the system will check if one of the listed conditions (SenderCode) is true for the certain order among with the set date range (Value1) and add promotional SKUs (ReceiverCode) to the according order.



An example of a record created is shown below.




BULK IMPORT


Bulk Import is convenient in case there are multiple rules that have to be created. It is performed by using an excel spreadsheet.


  1. Prepare an excel spreadsheet, using PROMOTIONS.xlsx template attached to this article. Logic to populate cells within it matches the logic used for a single record creation, outlined above.


  2. Click the "IMPORT" button within the "PROMOTIONS" page and choose the prepared file.


Once the process is completed, you will receive a success message:




RESTRICTIONS


SenderCode value has restriction in 256 symbols. If you have a lot of conditions to be checked at once, you should split them into a few records keeping in mind this restriction and use field Value2 as Promotion rule Id. These rules will be grouped into 1 based on Value2 key.


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article