Williams Trading is a wholesale distributor of adult novelty products, lingerie, and personal wellness items, supplying retailers with a vast selection of top brands, discreet shipping, and competitive pricing in the adult industry.
Step 1: Log into your Flxpoint account and navigate to the Connections tab, then select Fulfillment Sources.
Step 2: Under the Sources section, click on + Add Source to begin creating a new source for your Williams Trading connection.
Step 3: In the Create Source popup, name the source "Williams Trading" and select the appropriate type from the dropdown. Click Save.
Step 4: After saving, you’ll see "You have not created any integrations yet." Click Get Started to set up the integration.
Step 5: In the Setup Integrations popup, select Flx Supplier Directory (recommended) to proceed with the Williams Trading integration.
Step 6: In the Let's Find Your Supplier popup, search for "Williams Trading" in the Search Suppliers field. Select Williams Trading and click Select.
Step 7: In the Confirm Your Relationship With Supplier popup, check the box to confirm you have a reseller account with Williams Trading. Click Continue.
Step 8: Set up your Master SKU mapping (Inventory SKU → Master SKU → Listing SKU).
Note: For Williams Trading, Get Inventory (including pricing and quantity updates) does not require any credentials. You only need to ensure the Master SKU setup is correct. After saving, Flxpoint can automatically retrieve your product data from Williams Trading.
Note: For Williams Trading, Get Inventory (including pricing and quantity updates) does not require any credentials. You only need to ensure the Master SKU setup is correct. After saving, Flxpoint can automatically retrieve your product data from Williams Trading.
Step 9: To Send Orders to Williams Trading, you need to enable Automatically Send Orders and provide:
FTP Username
FTP Password
FTP Host (e.g.,
ftp.williamstrading.example.com)
FTP Port (e.g., 21)
Customer Number (provided by Williams Trading)
Once entered, click Save.
Step 10: To Get Shipments (tracking details) from Williams Trading, enable Automatically Get Shipments and provide the same FTP credentials used in Step 9.
After saving, Flxpoint will automatically retrieve shipment updates for orders placed with Williams Trading.
After saving, Flxpoint will automatically retrieve shipment updates for orders placed with Williams Trading.
×
![]()
Product Operations
The primary operation handles the bulk of your inventory management needs, while the secondary operation allows for more detailed control, such as focusing on specific products or updates
Get Inventory and Pricing & Quantity
Supported | William Trading - Get Inventory and Pricing & Quantity
Introduction to William Trading Get Inventory and Pricing & Quantity Integration
This guide helps you set up the William Trading Get Inventory and Pricing & Quantity integration. It syncs product data (e.g., attributes, SKUs) and updates stock levels and pricing, ensuring your catalog stays accurate. Let’s get started.
Purpose of This Integration
This integration imports and updates product data from William Trading:
- Get Inventory: Imports product details like attributes (e.g., title, description) and identifiers (e.g., SKU).
- Pricing & Quantity: Updates stock quantities and pricing (e.g., cost, MAP, MSRP).
It keeps your inventory accurate, preventing overselling and ensuring correct pricing. How the Integration Works
The integration has two parts with key differences:
1. Get Inventory: Uses direct feed downloads to retrieve product details from
http://downloads.williams-trading.com/export/williams/products_minimal.csv, including title, description, and SKU. No connection is required as the feed is common to all users. 2. Pricing & Quantity: Downloads stock and pricing data from
http://downloads.williams-trading.com/export/williams/products_minimal.csv (for pricing) and http://downloads.williams-trading.com/export/wholesale/map.csv (for MAP), updating quantities (e.g., 50 units) and prices (e.g., cost of $15). 3. Syncing: Data is processed and synced to your system, either manually or on a schedule (e.g., daily at 8 AM UTC). You can run the sync using the "Run Sync" option from the integration menu.
Note: If the feed URLs are inaccessible, neither Get Inventory nor Pricing & Quantity updates will complete. Configuration Options
You can customize the integration with these settings:
- Enable/Disable Fields: Choose which fields to import in the mapping template (e.g., enable/disable "MAP").
- Automatically Pricing & Quantity: Enable this to automatically update pricing and quantity data via the feed.
- Allow Create Variant: Enable this to allow creating variants while running Pricing & Quantity (default: disabled).
- Scheduling: Run manually or schedule (e.g., daily at 8 AM UTC) using the "Adjust Schedule" option.
Setup Instructions
Follow these steps to configure the integration:
1. Access the Integration: Go to the William Trading source and select "Get Inventory" and "Get Pricing & Quantity."
2. Configure Feed Access for Get Inventory and Pricing & Quantity: No authentication is required since the feeds are publicly accessible:
- Product Stock Feed:
http://downloads.williams-trading.com/export/williams/products_minimal.csv - Amazon MAP Feed:
For Pricing & Quantity, enable Automatically Pricing & Quantity to ensure updates are fetched via the feed. http://downloads.williams-trading.com/export/wholesale/map.csv 3. Configure Master SKU (Optional): Under "Master SKU," set how SKUs are linked:
- Inventory SKU → Master SKU → Listing SKU
Optionally, set an SKU prefix to differentiate William Trading products. 4. Create a Mapping Template: Define which fields to import (see below). Use the "Manage Mapping" option to access the mapping template.
5. Run the Integration: Start manually using "Run Sync" or schedule it via "Adjust Schedule."
Pricing Details
Pricing is sourced from William Trading Feed Files:
- Default Pricing: Includes Cost, MAP, MSRP (e.g., MSRP of $25).
- MAP Priority: Prioritizes
map.csv for MAP, falling back to products_minimal.csv if not found. Quantity Details
Stock quantities are sourced from the “QUANTITY” field in
products_minimal.csv (e.g., 50 units for SKU “WTC100CP”). Mapping Template Details
A mapping template controls how data is imported. In this version, you can only enable or disable fields.
Interface Overview
- The mapping screen is labeled “William Trading → Flxpoint” with subsections for “Get Inventory” and “Get Pricing & Quantity.”
- Buttons: Cancel and Save Mapping.
- Columns: Left (William Trading fields), Right (your system’s fields).
Mapping Options
- Enable: Import the field (e.g., enable “COST”).
- Disable: Ignore the field (e.g., disable “MAP”).
Required fields like “SKU” cannot be disabled. Available Source Fields
- Get Inventory: DESCRIPTION, DIMENSION UNIT, HEIGHT, LENGTH, WIDTH, MAP, MPN, MSRP, QUANTITY, TITLE, UPC, WEIGHT, WEIGHT UNIT, SKU, PARENT SKU.
- Pricing & Quantity: COST, MAP, MSRP, QUANTITY, SKU.
Complete Field Mappings
Get Inventory Mappings These mappings cover product details like attributes and identifiers from William Trading’s feed (
products_minimal.csv): SKU: A unique identifier for each product variant.
- Mapping: Maps to “SKU.”
- Reason: “SKU” is a unique identifier in William Trading, making it ideal for your SKU. This field is required and cannot be disabled.
Parent SKU: The identifier for the parent product.
- Mapping: Maps to “PARENT SKU.”
- Reason: Links variants to their parent product for better organization. This field is required and cannot be disabled.
Description: A detailed description of the product.
- Mapping: Maps to “DESCRIPTION.”
- Reason: Provides customers with more information about the product.
Dimension Unit: The unit of measure for dimensions.
- Mapping: Maps to “DIMENSION UNIT.”
- Reason: Standardizes the dimension unit for consistency.
Height: The height of the product.
- Mapping: Maps to “HEIGHT.”
- Reason: Provides dimensions for shipping and storage calculations.
Length: The length of the product.
- Mapping: Maps to “LENGTH.”
- Reason: Provides dimensions for shipping and storage calculations.
Width: The width of the product.
- Mapping: Maps to “WIDTH.”
- Reason: Provides dimensions for shipping and storage calculations.
MAP: The Minimum Advertised Price for the product.
- Mapping: Maps to “MAP.”
- Reason: Ensures compliance with pricing policies.
MPN: The Manufacturer Part Number for the product.
- Mapping: Maps to “MPN.”
- Reason: Provides an additional identifier for the product.
MSRP: The Manufacturer’s Suggested Retail Price.
- Mapping: Maps to “MSRP.”
- Reason: Provides the suggested retail price for the product.
Quantity: The stock quantity available for the product.
- Mapping: Maps to “QUANTITY.”
- Reason: Provides the current stock quantity for the product.
Title: The name or title of the product.
- Mapping: Maps to “TITLE.”
- Reason: The product title is essential for identifying products in your catalog.
UPC: The Universal Product Code for the product.
- Mapping: Maps to “UPC.”
- Reason: Helps verify the product identity in your system.
Weight: The weight of the product.
- Mapping: Maps to “WEIGHT.”
- Reason: Used to calculate shipping costs.
Weight Unit: The unit of measure for the weight.
- Mapping: Maps to “WEIGHT UNIT.”
- Reason: Standardizes the weight unit for consistency.
Pricing & Quantity Mappings These mappings cover stock levels and pricing from William Trading’s feeds (
products_minimal.csv, map.csv): Cost: The cost of the product for your business.
- Mapping: Maps to “COST.”
- Reason: Provides the base cost of the product in your inventory.
MAP: The Minimum Advertised Price for the product.
- Mapping: Maps to “MAP.”
- Reason: Ensures compliance with pricing policies.
MSRP: The Manufacturer’s Suggested Retail Price.
- Mapping: Maps to “MSRP.”
- Reason: Provides the suggested retail price for the product.
Quantity: The stock quantity available for the product.
- Mapping: Maps to “QUANTITY.”
- Reason: Provides the current stock quantity for the product.
Practice Mapping Try enabling or disabling the “Cost” field:
Troubleshooting
If issues arise:
- Verify the feed URLs are accessible:
http://downloads.williams-trading.com/export/williams/products_minimal.csv and http://downloads.williams-trading.com/export/wholesale/map.csv. If the feeds are down, contact William Trading or Flxpoint support. - Ensure required fields like “SKU” and “PARENT SKU” are enabled.
- Check logs using the "View Logs" option if the sync fails.
- Contact Flxpoint support if needed.
Conclusion
With this integration set up, your system will sync product details, stock levels, and pricing from William Trading, keeping your catalog accurate.
Order Operations
It submits orders to vendors for fulfillment and subsequently imports the shipment details, ensuring an integration between order processing and shipment tracking.
Send Orders
Supported | William Trading - Send Orders
Introduction to William Trading Send Orders Integration
This guide helps you set up the William Trading Send Orders integration. It allows you to send purchase orders (POs) or fulfillment requests (FRs) to William Trading via their SOAP API, ensuring your orders are processed and shipped efficiently. Let’s get started.
Purpose of This Integration
The William Trading Send Orders integration enables you to send purchase orders or fulfillment requests to William Trading, allowing them to process and ship your orders. This integration:
- Automates the submission of order details, such as product SKUs, quantities, billing/shipping addresses, and shipping methods.
- Uses a SOAP API to securely communicate with William Trading, ensuring accurate and timely order processing.
This helps streamline your supply chain, reduce manual effort, and minimize errors in order fulfillment. How the Integration Works
The integration follows a clear process to send orders to William Trading:
1. Connecting via SOAP API: It connects to William Trading’s SOAP endpoint at
http://muffsandcuffs.com/WMS/webservices/SOAP/ using a username and password. The WSDL (Web Services Description Language) file is available at http://muffsandcuffs.com/WMS/webservices/SOAP/?wsdl. 2. Mapping Order Data: A mapping template formats your order data (e.g., SKU, quantity, billing/shipping addresses) into the structure required by William Trading’s API.
3. Sending Orders: Once configured, the integration sends orders automatically or manually, based on your settings. You can schedule the process to run at specific times (e.g., daily at 8 AM UTC).
Note: You’ll need a William Trading account with API credentials (username, password, and customer number) to use this integration. If you need help obtaining these, contact Flxpoint support, and we’ll assist by coordinating with William Trading on your behalf. Configuration Options
You can customize the integration with the following settings:
- William Trading Customer Number: Enter your unique customer number provided by William Trading (e.g., EYEOPR001i). This is required for order processing.
- Hold for X Hours: Set a delay (in hours) before sending orders, giving you time to review them if needed (e.g., hold for 2 hours).
- Send During Business Hours: Enable this to send orders only during business hours, ensuring timely processing by William Trading.
- Scheduling: Run manually or schedule (e.g., daily at 8 AM UTC) using the "Adjust Schedule" option.
Setup Instructions
Follow these steps to configure the Send Orders integration:
1. Access the Integration: Go to the William Trading source and select "Send Orders."
2. Configure SOAP API Connection: Under "Authentication Details," enter:
- Host:
http://muffsandcuffs.com/WMS/webservices/SOAP/ (pre-filled). - API Username: Enter the username provided by William Trading (e.g., BYWilson).
- API Password: Enter the password provided by William Trading.
Test the connection to confirm it works. William Trading supports a "ping" test using random credentials to expect a 401 error, confirming the endpoint is active. Save the connection once successful. 3. Configure Settings: Adjust the following options as needed:
- Enter your William Trading Customer Number (e.g., EYEOPR001i), which is required for order submission.
- Set a Hold for X Hours delay if you want to review orders before sending (e.g., 2 hours).
- Enable Send During Business Hours to send orders only during business hours.
4. Create a Mapping Template: Define which fields to send (see below). Use the "Manage Mapping" option to access the mapping template.
5. Run the Integration: Start manually using "Run Sync" or schedule it via "Adjust Schedule."
Shipping Methods
William Trading requires the shipping method to be included with the order. You can map your system’s shipping options to William Trading’s expected shipping codes. For example:
- Best Rate: Supplier Shipping Code:
Ensure your mapping template includes the appropriate shipping method for each order. BESTRATE, Supplier Shipping Carrier Name: Best Rate. Mapping Template Details
A mapping template controls how your order data is sent to William Trading. In this version, you can only enable or disable fields.
Interface Overview
- The mapping screen is labeled “William Trading → Flxpoint” with a subsection for “Send Orders.”
- Buttons: Cancel and Save Mapping.
- Columns: Left (your system’s fields), Right (William Trading fields).
Mapping Options
- Enable: Send the field to William Trading (e.g., enable “Bill To Address 1”).
- Disable: Ignore the field (e.g., disable “Bill To Address 2”).
Required fields like “Items: SKU” cannot be disabled. Available Source Fields
- Billing Address Fields: Bill To Address 1, Bill To Address 2, Bill To City, Bill To Country, Bill To Email, Bill To First Name, Bill To Last Name, Bill To State, Bill To Zip.
- Order Fields: Items: SKU, Items: Name, Items: Price, Items: Quantity, Notes, Reference.
- Shipping Address Fields: Ship To Address 1, Ship To Address 2, Ship To City, Ship To Country, Ship To First Name, Ship To Last Name, Ship To State, Ship To Zip.
- Shipping Method Fields: Ship Via Code.
Complete Field Mappings
Send Orders Mappings These mappings cover the order details sent to William Trading via the SOAP API:
Bill To Address 1: The primary billing address line.
- Mapping: Maps to “Bill To Address 1.”
- Reason: Ensures William Trading has the correct billing address for the order.
Bill To Address 2: The secondary billing address line.
- Mapping: Maps to “Bill To Address 2.”
- Reason: Provides additional billing address details if needed.
Bill To City: The city for the billing address.
- Mapping: Maps to “Bill To City.”
- Reason: Specifies the billing city for accurate order processing.
Bill To Country: The country for the billing address.
- Mapping: Maps to “Bill To Country.”
- Reason: Ensures the correct country is associated with the billing address.
Bill To Email: The email address for billing contact.
- Mapping: Maps to “Bill To Email.”
- Reason: Provides a contact email for billing-related communication.
Bill To First Name: The first name of the billing contact.
- Mapping: Maps to “Bill To First Name.”
- Reason: Identifies the billing contact for the order.
Bill To Last Name: The last name of the billing contact.
- Mapping: Maps to “Bill To Last Name.”
- Reason: Completes the billing contact’s name for the order.
Bill To State: The state for the billing address.
- Mapping: Maps to “Bill To State.”
- Reason: Specifies the billing state for accurate order processing.
Bill To Zip: The postal code for the billing address.
- Mapping: Maps to “Bill To Zip.”
- Reason: Ensures the correct postal code is used for billing.
Items: SKU: The unique identifier for the product.
- Mapping: Maps to “Items: SKU.”
- Reason: Allows William Trading to identify the product in their system. This field is required and cannot be disabled.
Items: Name: The name or title of the product.
- Mapping: Maps to “Items: Name.”
- Reason: Provides a description of the product for clarity.
Items: Price: The price of the product.
- Mapping: Maps to “Items: Price.”
- Reason: Specifies the cost of the item for order verification.
Items: Quantity: The number of units to order.
- Mapping: Maps to “Items: Quantity.”
- Reason: Tells William Trading how many units to ship.
Notes: Additional notes for the order.
- Mapping: Maps to “Notes.”
- Reason: Allows you to include any special instructions or comments.
Reference: A reference number for the order.
- Mapping: Maps to “Reference.”
- Reason: Provides a unique identifier for tracking the order.
Ship To Address 1: The primary shipping address line.
- Mapping: Maps to “Ship To Address 1.”
- Reason: Ensures William Trading ships to the correct address.
Ship To Address 2: The secondary shipping address line.
- Mapping: Maps to “Ship To Address 2.”
- Reason: Provides additional shipping address details if needed.
Ship To City: The city for the shipping address.
- Mapping: Maps to “Ship To City.”
- Reason: Specifies the shipping city for accurate delivery.
Ship To Country: The country for the shipping address.
- Mapping: Maps to “Ship To Country.”
- Reason: Ensures the correct country is associated with the shipping address.
Ship To First Name: The first name of the shipping contact.
- Mapping: Maps to “Ship To First Name.”
- Reason: Identifies the shipping contact for the order.
Ship To Last Name: The last name of the shipping contact.
- Mapping: Maps to “Ship To Last Name.”
- Reason: Completes the shipping contact’s name for the order.
Ship To State: The state for the shipping address.
- Mapping: Maps to “Ship To State.”
- Reason: Specifies the shipping state for accurate delivery.
Ship To Zip: The postal code for the shipping address.
- Mapping: Maps to “Ship To Zip.”
- Reason: Ensures the correct postal code is used for shipping.
Ship Via Code: The shipping method for the order.
- Mapping: Maps to “Ship Via Code.”
- Reason: Ensures the correct shipping method is used for the order.
Practice Mapping Try enabling or disabling the “Bill To Address 1” field:
Troubleshooting
If issues arise:
- Verify the SOAP API connection to
http://muffsandcuffs.com/WMS/webservices/SOAP/ and ensure your username and password are correct. An error like “401 Unauthorized” often indicates incorrect credentials—double-check with William Trading. - Ensure your William Trading Customer Number (e.g., EYEOPR001i) is correctly entered. An “Invalid Customer Specified” error means the customer number is incorrect—verify with William Trading.
- Check that required fields like “Items: SKU” are enabled in the mapping template.
- Confirm your William Trading account has the necessary permissions to create orders. Contact William Trading or Flxpoint support if needed.
- Check logs using the "View Logs" option if the sync fails.
Conclusion
With this integration set up, you can send orders to William Trading seamlessly, ensuring efficient order processing and fulfillment.
Get Shipments
Supported | William Trading - Get Shipments
Introduction to William Trading Get Shipments Integration
This guide helps you set up the William Trading Get Shipments integration. It retrieves shipment details for your orders via their SOAP API, including tracking numbers, shipping methods, and item details, keeping you informed about deliveries. Let’s get started.
Purpose of This Integration
The William Trading Get Shipments integration retrieves shipment details for orders processed by William Trading, helping you track and manage deliveries. This integration:
- Pulls shipment data, including tracking numbers, shipping methods, and item SKUs, to keep your records updated.
- Uses a SOAP API to securely communicate with William Trading, ensuring accurate and timely shipment information.
This helps you provide customers with tracking information and manage your fulfillment process effectively. How the Integration Works
The integration follows a clear process to retrieve shipment details from William Trading:
1. Connecting via SOAP API: It connects to William Trading’s SOAP endpoint at
http://muffsandcuffs.com/WMS/webservices/SOAP/ using a username and password. The WSDL file is available at http://muffsandcuffs.com/WMS/webservices/SOAP/?wsdl. 2. Mapping Shipment Data: A mapping template formats the API response data (e.g., tracking number, shipping method, SKU) into your system’s shipment fields.
3. Retrieving Shipments: Once configured, the integration retrieves shipment details automatically or manually, based on your settings. You can schedule the process to run at specific times (e.g., daily at 8 AM UTC).
Note: You’ll need a William Trading account with API credentials (username and password) to use this integration. Configuration Options
There are no additional configuration settings required for this integration beyond the initial connection setup and mapping template. However, you can:
- Scheduling: Run manually or schedule (e.g., daily at 8 AM UTC) using the "Adjust Schedule" option.
Setup Instructions
Follow these steps to configure the Get Shipments integration:
1. Access the Integration: Go to the William Trading source and select "Get Shipments."
2. Configure SOAP API Connection: Under "Authentication Details," enter:
- Host:
http://muffsandcuffs.com/WMS/webservices/SOAP/ (pre-filled). - API Username: Enter the username provided by William Trading (e.g., BYWilson).
- API Password: Enter the password provided by William Trading.
Test the connection to confirm it works. Save the connection once successful. 3. Configure Settings: There are no additional settings to configure for this integration. Simply save and proceed.
4. Create a Mapping Template: Define which fields to import (see below). Use the "Manage Mapping" option to access the mapping template.
5. Run the Integration: Start manually using "Run Sync" or schedule it via "Adjust Schedule."
Carrier & Methods
William Trading provides carrier and shipping method information via the SOAP API. You can map these to your system’s fields:
- Carrier: The shipping carrier used (e.g., “UPS”).
- Method: The shipping method (e.g., “Ground”).
Ensure your mapping template includes these fields to capture the correct carrier and method for each shipment. Mapping Template Details
A mapping template controls how shipment data is imported. In this version, you can only enable or disable fields.
Interface Overview
- The mapping screen is labeled “William Trading → Flxpoint” with subsections for “Shipment Fields” and “Shipment Item Fields.”
- Buttons: Cancel and Save Mapping.
- Columns: Left (William Trading fields), Right (your system’s fields).
Mapping Options
- Enable: Import the field (e.g., enable “Tracking Number”).
- Disable: Ignore the field (e.g., disable “Shipping Cost”).
Required fields like “SKU” cannot be disabled. Available Source Fields
- Shipment Fields: Carrier, Fulfillment Request Number, Method, Note, Shipped At, Shipping Cost, Tracking Number, Tracking URL.
- Shipment Item Fields: All Custom Fields, Quantity, SKU.
Complete Field Mappings
Shipment Fields These mappings cover shipment details from William Trading’s SOAP API:
Carrier: The shipping carrier used for the shipment.
- Mapping: Maps to “Carrier.”
- Reason: Identifies the carrier handling the shipment.
Fulfillment Request Number: The associated fulfillment request number.
- Mapping: Maps to “Fulfillment Request Number.”
- Reason: Links the shipment to the original order.
Method: The shipping method used.
- Mapping: Maps to “Method.”
- Reason: Specifies the shipping method.
Note: Any additional notes about the shipment.
- Mapping: Maps to “Note.”
- Reason: Captures any special instructions or comments.
Shipped At: The date the shipment was sent.
- Mapping: Maps to “Shipped At.”
- Reason: Provides the shipment date for tracking purposes.
Shipping Cost: The cost of shipping.
- Mapping: Maps to “Shipping Cost.”
- Reason: Provides the shipping cost for record-keeping.
Tracking Number: The tracking number for the shipment.
- Mapping: Maps to “Tracking Number.”
- Reason: Allows you to provide customers with tracking information.
Tracking URL: The URL for tracking the shipment.
- Mapping: Maps to “Tracking URL.”
- Reason: Provides a direct link to track the shipment.
Shipment Item Fields These mappings cover the items in the shipment:
All Custom Fields: Custom fields like serial numbers.
- Mapping: Maps to “All Custom Fields.”
- Reason: Imports any custom fields associated with the item.
Quantity: The quantity of items shipped.
- Mapping: Maps to “Quantity.”
- Reason: Specifies how many units of the item were shipped.
SKU: The unique identifier for the item in the shipment.
- Mapping: Maps to “SKU.”
- Reason: Matches the shipped item to your system’s inventory. This field is required and cannot be disabled.
Practice Mapping Try enabling or disabling the “Tracking Number” field:
Troubleshooting
If issues arise:
- Verify the SOAP API connection to
http://muffsandcuffs.com/WMS/webservices/SOAP/ and ensure your username and password are correct. - Ensure required fields like “SKU” are enabled in the mapping template.
- Check logs using the "View Logs" option if the sync fails.
- Contact Flxpoint support if needed.
Conclusion
With this integration set up, you can retrieve shipment details from William Trading, keeping your tracking information up-to-date.