Reebelo Legacy FTP Account Integration

Overview

Reebelo is a leading online retailer of new and refurbished phones, tablets, and other electronics. You can integrate your Reebelo account with Sellercloud through customized Profiles and Scheduled Tasks. The workflow allows regular Inventory and price updates, order import, and tracking export.

Prerequisites

You need to have a seller account with Reebelo and discuss setting up an SFTP connection. They will provide you with the necessary credentials for the setup.

Next, you will have to create two Export Profiles and an Import Profile, which will then be set on three separate Scheduled tasks, as well as two Saved Searches: for Products and for Orders.

We offer the option to Integrate with Reebelo Canada. To do this, you will need to set up a dedicated Company configured with the CA Country code and currency. Request Custom Product Column ReebeloCAEnabled to be created for your account by Sellercloud Support. The rest of the setup is identical to the Reebelo US Integration outlined below.

Create Profiles

You need to map three Profiles using our Import Mapping Tool and Export Mapping Tool. You can download the Reebelo templates from the sections below or contact Reebelo directly to obtain them.

For the two Export Profiles:

1. Navigate to Settings > Mapping Tools > Manage Export Mapping Profiles.
2. Click the blue Actions icon in the bottom right corner > Create.
3. On the creation wizard pop-up, fill in the required fields:
   1. Profile Name – for example, Reebelo Inventory Feed and Reebelo Tracking Export
   2. Profile type – set to the first to Product and the second to Order
      1. For the Profile Type Order, a few additional fields will appear. Set Export Type to Tracking and enable Export fully shipped orders only.  The Vendor field can remain empty.
   3. Export File Type – set to CSV.
   4. Check Export File with Headers.
4. Click Template File. Find and select the downloaded template from your device.
5. Click Add.

For the Import Profile:

1. Navigate to Settings > Mapping Tools > Manage Import Mapping Profiles.
2. Click the blue Actions icon in the bottom right corner > Create.
3. On the creation wizard pop-up, fill in the required fields:
   1. Profile Name – for example, Reebelo Orders. `
   2. Import type – set to Order.
   3. Skip First Rows – set to 0.
   4. Check Order is Paid, and Order is Authorized.
   5. Order Source – set to Website.
   6. Company – choose the new Reebelo-designated company you created.
   7. Warehouse – select the warehouse from which you will fulfill your Reebelo Orders.
   8. Check File contain headers.
4. Click Template File. Find and select the downloaded template from your device.
5. Click Create.

Map Inventory Export Profile Fields

Click here to download template

Sellecloud will automatically send regular inventory and price feeds to Reebelo through this profile.  Go to Settings > Mapping Tools > Manage Export Profiles > Open the Reebelo Orders Profile > Click Edit > Map the following fields:

• SKU – map it to bvc_Product.ID
• Price – map it to bvc_Product.SitePrice
• MinPrice – map it to bvc_Product_Properties_UserDefinied.REEBELO_MINPRICE
• Stock – map it to bvc_Product.AggregateQty

Map Tracking Export Profile Fields

Click here to download template

Sellecloud will regularly send Reebelo the Tracking information of orders you have fulfilled. Go to Settings > Mapping Tools > Manage Export Profiles > Open the Reebelo Orders Profile > Click Edit > Map the following fields:

• OrderName – map it to bvc_Order.OrderSourceOrderID
• SKU – map it to bvc_OrderItem.ProductID
• Quantity – map it to bvc_OrderItem.Qty
• Carrier – map it to bvc_Order.ShippingCarrier
• Tracking – map it to bvc_Order.TrackingNumberProvided
• Note – map it to bvc_OrderItem.SerialNumbers

Map Order Import Profile Fields

Click here to download template

Sellercloud will regularly import all new Reebelo orders through this Profile. Go to Settings > Mapping Tools > Manage Import Profiles > Open the Reebelo Orders Profile > Click Edit > Map the following fields:

• OrderName – map to Order_OrderSourceOrderID
• SKU – map to Order_Item_ProductID
• Quantity – map to Order_Item_Qty
• Price – map to Order_Item_SalePrice
• CreatedAt – map to Order_TimeOfOrder
• ShippingFirstName – map to Order_ShippingFirstName
• ShippingLastName – map to Order_ShippingLastName
• ShippingAddress1 – map to Order_ShippingStreetLine1
• ShippingAddress2 – map to Order_ShippingStreetLine2
• ShippingCity – map to Order_ShippingCity
• ShippingPhone – map to Order_ShippingPhoneNumber
• ShippingStateCode – map to Order_ShippingStateCode
• ShippingPostalCode – map to Order_ShippingPostalCode
• ShippingCountryCode – map to Order_ShippingCountryCode

Create Scheduled Tasks

To ensure seamless integration, you must automate the data transfer by creating Scheduled Tasks for each Profile.

Inventory Export Task

You can export the inventory and price of selected products and send them to Reebelo. This task type requires a Saved View for products. 

Optionally, if you don’t sell all of your products on Reebelo, you can filter by a custom column called ReebeloEnabled (or ReebeloCAEnabled if you are integrating Reebelo Canada). You can also add more filters and custom columns based on your preference. Please contact Sellercloud Support if you would like to use new Custom Columns.

To create a scheduled task that regularly exports inventory to Reebelo:

1. Navigate to Settings > Scheduled Tasks.
2. In the creation wizard pop-up, fill in:
   1. Company – select the Reebelo-designated company.
   2. Task Type – set to Export Products.
   3. Task Name – enter a name, for example, Reebelo Inventory Feed.
   4. Start Date – this is the date when the task will run automatically for the first time. However, If you enable the task at a later day, this date will be ignored.
3. Click Create.

Next, go to the Scheduled task to finish the configuration and click Edit:

1. In the Frequency panel, set your task to run every 30 minutes.
2. In the Details panel:
   1. User ID – select your username.
   2. Saved Search – select the Product Saved View you created.
   3. Export Via – select Export Mapping Profile: Reebelo Inventory Feed
   4. File Name – make sure the name you fill in ends in .csv
3. In the Export Options Panel:
   1. Export To – select FTP.
   2. Fill in the SFTP credentials provided by Reebelo.
   3. Enable Use Passive and Use Secure FTP.
4. In the General panel, click the toggle button to enable the task.
5. Click Save.

Tracking Export Task

Tracking information for orders fulfilled through Sellercloud will be sent to Reebelo on a regular basis. Orders without tracking information should not be included in this export.

This task type requires a Saved View for orders. When creating your saved search, it is recommended to filter by Company, Order Status: In Process or Completed, and Shipping Status: Shipped. Optionally, you can also filter by Payment Status, Tracking Uploaded: Not Uploaded (this will filter for orders that have not had their tracking information exported to the marketplace), and Exported, as well as add more filters based on your preference.

1. Navigate to Settings > Scheduled Tasks.
2. In the creation wizard pop-up, fill in:
   1. Company – select the Reebelo-designated company.
   2. Task Type – set to Export Orders.
   3. Task Name – for example, Reebelo Tracking Export.
   4. Start Date – this is the date when the task will run automatically for the first time. However, If you enable the task at a later day, this date will be ignored.
3. Click Create.

Next, go to the Scheduled task to finish the configuration and click Edit:

1. In the Frequency panel, you can set the Task to run less regularly (for example, every 12 hours), as the tracking export does not need to be “in real time” like the available inventory levels.
2. In the Details panel:
   1. User ID – select your username.
   2. Saved Search – select the Order Saved View you created.
   3. Export Via – select Export Mapping Profile: Reebelo Tracking Export.
   4. File Name – make sure the name you fill in ends with .csv
   5. Enable Mark Orders As Exported, and This Is Tracking Export.
3. In the Export Options Panel:
   1. Export To – select FTP.
   2. Fill in the SFTP credentials provided by Reebelo.
   3. Enable Use Passive and Use Secure FTP.
4. In the General panel, click the toggle button to enable the task.
5. Click Save.

Order Import Task

Follow these steps to create a scheduled task that regularly imports orders from Reebelo:

1. Navigate to Settings > Scheduled Tasks.
2. In the creation wizard pop-up, fill in:
   1. Company – select the Reebelo-designated company.
   2. Task Type – set to Import Orders.
   3. Task Name – enter a name, for example, Reebelo Order Import.
   4. Start Date – this is the date when the task will run automatically for the first time. However, If you enable the task at a later day, this date will be ignored.
3. Click Create.

Next, go to the Scheduled task to finish the configuration and click Edit:

1. In the Frequency panel, set your task to run every 30 minutes.
2. In the Details panel:
   1. Create Orders for Company – choose the Reebelo-designated company.
   2. Plugin– select Profile: Reebelo Orders.
3. In the Import Options Panel:
   1. Import From – select FTP.
   2. Fill in the SFTP credentials provided by Reebelo.
   3. Enable Use Passive and Use Secure FTP.
4. In the General panel, click the toggle button to enable the task.
5. Click Save.