Big improvement. Seller-Online API integration

There is a task to set up Seller-Online API integration. Seller-Online is a contractor for handling orders from foreign marketplaces. API v1.0 (We use it to integrate orders and finances): https://app.swaggerhub.com/apis/seller-online/seller-online-user/1.0.1#/ API v2.0 (Used to create parcel shipments with “Seller-Online Shipping”). https://api.seller-online.com/swagger-ui/ I want to divide the improvements into blocks and understand how much the cost of all the improvements will be and how much the cost of each block. (If the budget does not allow to implement everything, we may implement a part) Improvement blocks: 1. Import Finance Seller-Online 2. Import orders that entered Seller-Online 3. Formation of sending parcels with “Sending Seller-Online” 4. Formation of sending parcels from Seller-Online (UkrPoshta) 5. Refinement of the integration of “Ukrposhta Delivery Service” so that you can send parcels through UkrPoshta abroad. According to paragraph 4 or 5 of the TOR, we will form one of these days. We add. Each of the blocks was translated into subtasks to make it easier to communicate. Info for yourself: The track number (in the USA) appears when the parcel has the status “In transit to the distribution center” At the Seller-Online warehouse, the parcel is determined by the “Parcel Number”. Ideally, if it is a barcode. Improvement in OneBox market “Integration with Seller-Online” We create “Integration with Seller-Online” in OneBox market It has the ability to create integrations as in Prom https://prnt.sc/vmd3fc There will be several integrations, to different Seller-Online accounts, for each of its API keys and access data. We make one of the integrations “Standard for sending” Further in all auth. actions we will choose in the settings which integration to use. (Choose an integration) 1. Calculation of finalization Import finance Seller-Online. https://app.swaggerhub.com/apis/seller-online/seller-online-user/1.0.1#/ It is necessary to pull all financial transactions in OneBox via API. To do this, a wallet has been created into which operations need to be imported. We import the following data (https://prnt.sc/vm822f): date and time Purpose (import to comment) Sum Seller-Online order number (We check with the “External ID”, and if they match, we attach the payment to this order) Importing with the help of “Automatic actions once a minute” In ed. In action, we configure the following items: Starting frequency (in minutes): indicated by a number. - We write a number, which means after how many minutes to start the auto. action. User from which payments will be created: drop-down list with employees. Account to which payments will be credited: drop-down list with payment accounts. Select integration: Select integration (from which Seller-Online account to pull data). 2. Calculation of completion Import of orders from Seller-Online. https://app.swaggerhub.com/apis/seller-online/seller-online-user/1.0.1#/ It is necessary to pull orders via API that have arrived in Seller-Online. We process orders from dropshippers as well as orders from our stores. These orders go to Seller-Online accounts. Everyone has their own office, orders from several stores can fall into one office. We share 3 people in one process: Responsible manager) Client Recipient If the order is from a dropshipper, then he is a client. Our manager who processes the order is responsible, and the person who ordered from the dropshipper is the recipient. In this case, with Seller-Online, we pull out the recipient's data. If the order is from our stores, then our manager is responsible, and the client and recipient are the same person, whose data we pull from Seller-Online. Therefore, we do 2 types of import orders: Once every n min. we import ALL orders that were received in Seller-Online. We create a process manually, translate the stage from author. action, OneBox pulls data from Seller-Online according to “External ID”. Once every n min. import ALL orders received by Seller-Online. We import with the help of “Automatic actions once a minute” ALL orders from Seller-Online. In ed. In action, we configure the following items: Starting frequency (in minutes): indicated by a number. - We write a number, which means after how many minutes to start the auto. action. Select integration - Select integration (from which Seller-Online account to pull data). Business process - which BP the order falls into. Dropdown list with BP. Status - What is the status of the order. Drop-down list with the stages of the selected BP Process source - Drop-down list with process sources. We set up a responsible process regarding the store. https://prnt.sc/vmbiz0 * If the responsible person is not in the list, then the client manager is assigned. (In a dropshipping situation) We create a process manually, translate the stage from author. action, OneBox pulls data from Seller-Online according to “External ID”. Since not all dropshippers want us to import all of their orders from Seller-Online, there will be this import option for them. In the client (dropshipper) card, we indicate the integration (from which Seller-Online account to pull data). We do auto. step action. When switching to it, OneBox looks at the “External ID” of the process (which the dropshipper will insert into the created order), and according to it pulls up data from Seller-Online. We import the following data: Name: put in the comment of the process. Product SKU: we add it to the comment of the process. (Articles via API are transferred separated by commas) Order Number: This is the Seller-Online order number. (In OneBox: “External ID”) Number at the place of purchase (sale): This is the order number in the marketplace, which transfers the order to Seller-Online. (In OneBox: Create an “additional order field”) The name of the store that the order went to. The data below must be imported as recipient data. (NOT the client, but the recipient). If there are no variables, we will create them as “Add. process fields. The same data will be used when creating a TTN by UkrPoshta and sending it to Seller-Online (another revision below) First Name (In OneBox: “Recipient Name”) Last name (In OneBox: “Recipient's last name”) Phone (In OneBox: “Recipient's Phone”) Country (In OneBox: “Country of Recipient”) City (In OneBox: “Recipient City”) Region/State (In OneBox: “Recipient Region/State”) Locality (In OneBox: “Recipient’s locality”) Index (In OneBox: “Recipient Index”) Address (In OneBox: “Recipient Address”) Email (In OneBox: “Recipient Email”) 3. Calculation of completion “Formation of sending parcels through “Sending Seller-Online”” Consolidation is a way to send abroad, we send all packages by new mail or by taxi to Seller-Online in Kyiv, they pack them in one box and send them to their warehouse in America, and already there each package is sent separately to customers in the USA. Auth. step action. When moving to a stage. “Seller-Online Shipping Options” In the Seller-Online account, after entering the recipient's data, we are given a choice of sending option (https://prnt.sc/vmrgp3) with different terms and prices. In order to form a package, we first need to choose which delivery option we need. We can do this by pulling the option through the API (/v2/shipping/shipments/get-carriers) options. I see it like this: According to the “External ID” of the process/order, through the API we pull out shipping options from Seller-Online. We transfer the recipient's data https://prnt.sc/vmemmh from OneBox to Seller-Online. Transfer data about the parcel (https://prnt.sc/vmf0j8) from OneBox to Seller-Online: Product Name) Length (cm) Width (cm) Height (cm) Weight, kg) We transfer the item “in person” (https://prnt.sc/vmf6y7) to OneBox, we will make an additional. process field “In person”. Passing the insurance item (This is a new item, it will be added one of these days to the Seller-Online API) Seller returns shipping options to us, with terms and prices. We put them in a separate block in the process. In the block in the process it is displayed like this: https://prnt.sc/vmrtl8 Delivery name Price ☐ Timing Then we choose the type of delivery, and transfer to the next. stage. Where with the help of trace. ed. actions, the shipment will be created. * As a standard, the cheapest shipping should be selected from those returned by the Seller. You need to make templates according to the dimensions that will be in the product card. They will be standard output to the process when we add a product. If necessary, we will change them (before moving to the stage) https://prnt.sc/vmf9cd - an example. Auth. step action. When moving to a stage. “Create Shipment via “Seller-Online Shipment”” In the previous. ed. In the action, we pulled out delivery options and prices, and when we go to this stage, we create a shipment using the selected method. We return from Seller-Online to the OneBox process: Shipping cost, if provided in the car settings. action Parcel number (Which was formed by https://prnt.sc/vmsj9y) in add. process field. “Seller Parcel Number” In ed. In action, we configure the following items: Integrations: Dropdown list of all integrations. And the item “Take from the client’s card” (then the integration is taken from the client’s / dropshipper’s card) If no integration is specified in the client card, “standard for sending” is selected. If the registration of the shipment is through “standard for shipment”, then the cost of delivery is displayed in the process. Auth. step action. “Move the process to this stage if the status of “Sending Seller-Online” has changed” https://prnt.sc/vmftog is an example. In ed. In action, we configure the following items: Integrations: Dropdown list of all integrations. And the item “Take from the client’s card” (then the integration is taken from the client’s / dropshipper’s card) Depending on the chosen integration, OneBox checks the status in the required Seller-Online account. List of statuses (https://prnt.sc/vmfs27): customer_created Created by the customer customer_sent Sent by customer in_ua_warehouse Accepted for warehouse in Ukraine transit_ua_buyer In transit to the buyer in_transit_warehouse Awaiting shipment to customer delivered Delivered to the buyer return_processed Return processed frozen Detained in Kyiv leave_usa Left the USA transit_ua_usa In transit to the distribution center transit_usa_buyer Transferred to the delivery service from the distribution center in_svh Accepted to the warehouse in the distribution center svh_process Processing in warehouse at distribution center partially_from_np Partially received from the postal service in Ukraine full_from_np Received from postal service in Ukraine customer_sent_back Sent back to the customer customer_returned Delivered back to the customer transit_buyer_usa In transit from the buyer to the warehouse Track numbers https://prnt.sc/vmgsai - Seller-Online has 2 variables with a track number. The first track number is the TTN of the new mail, we create it and insert it into the OneBox order when we send all orders to the Seller-Online warehouse in one parcel. The second track number is created by Seller-Online, for each individual package across the USA, we must pull it out from Seller-Online. For this, 2 more auth. step actions: Auth. step action. “Import track numbers from Seller-Online” In ed. In action, we configure the following items: Integrations: Dropdown list of all integrations. And the item “Take from the client’s card” (then the integration is taken from the client’s / dropshipper’s card) If no integration is specified in the client card, “standard for sending” is selected. When moving to the stage, OneBox, according to the order number, pulls up the parcel number from the Seller-Online track. Auth. step action. “Transfer TTN Nova Poshta to Seller-Online”” In ed. In action, we configure the following items: Integrations: Dropdown list of all integrations. And the item “Take from the client’s card” (then the integration is taken from the client’s / dropshipper’s card) If no integration is specified in the client card, “standard for sending” is selected. At this stage, we transfer the TTN of Nova Poshta from OneBox (From the additional process field to Seller-Online.