GunBroker is a popular online auction platform specifically tailored for firearms and related accessories. As a sales channel in Flxpoint, it allows users to list, sync, and manage their firearm inventory seamlessly across the marketplace. GunBroker supports various operations such as linking, syncing, and publishing listings, as well as managing orders. It is particularly useful for sellers looking to reach a niche market of firearm enthusiasts, with features that help automate and streamline the process of selling firearms online.
How to connect
- Search for GunBroker in the directory and select it
- Enter a Channel Name (e.g., "GunBroker")
- Click Save & Next to proceed
- Import Listings: To create and update listings and products in Flxpoint
- Get Orders: To import new orders and send back acknowledgments
- Start Import Listings to create and update listings and products in Flxpoint
- Start Get Orders to import new orders and send back acknowledgments
- Use other operations like Sync Listings, Publish Listings, Sync Orders, and Send Accounting Shipments as needed
- Adjust any skipped steps from the channel settings
Listing Operations
Flxpoint allows you to manage product listings on eBay by syncing inventory, updating product details, and controlling pricing and availability. This ensures accurate and real-time updates across your eBay store.
Import Listings
- Import GunBroker listings into Fixpoint for centralized management.
- Align Fixpoint categories with GunBroker’s structure (e.g., “Ammo” to “Centerfire Handgun Rounds”).
- Link listings to Fixpoint records using identifiers like SKU (e.g., “GB12345”).
- Pause imported listings to prevent syncing until verified.
-
1 Fetch Listings: Retrieves listings via
https://api.gunbroker.com/v1/auction/fixedPrice/listing
. -
2 Add Attributes: Adds
IsFixedPrice
attribute for fixed price listings. - 3 Import Data: Imports details like quantity (e.g., “5”), price (e.g., “$599.99”), and images.
- 4 Link Listings: Links by SKU or creates new records if no match.
- 5 Category Alignment: Maps GunBroker Category IDs to Fixpoint categories (e.g., “12345” to “Ammo”).
- 6 Paused Status Option: Sets listings to “Paused” if enabled.
- Paused Status: Set listings to “Paused” to prevent syncing until verified.
- Master SKU: Select SKU, UPC, or MPN (e.g., SKU “GB12345”) as the primary identifier.
-
Product & Listing Management:
- Create new products and listings only.
- Create and update existing products and listings.
- Category Mapping: Align Fixpoint categories with GunBroker IDs.
- Advanced Mapping Rules: Modify data (e.g., split values) for alignment.
- 1 Add the Integration: In Integrations, select GunBroker and “Import Listings.”
- 2 Connect to GunBroker: Use existing or new API credentials.
- 3 Configure Settings: Enable “Paused” status, select Master SKU (e.g., SKU), choose management options, align categories.
- 4 Apply Advanced Mapping Rules (Optional): Set rules to modify data.
- 5 Run the Integration: Save to import listings.
- 6 Unpause Listings: Go to Products > Actions > Unpause Listings when ready.
- Quantity: Available quantity (e.g., “5”).
- Images: Thumbnail URLs (e.g., “https://example.com/image.jpg”).
- Categories: Cat1 (name, e.g., “Centerfire Handgun Rounds”), Cat2 (code, e.g., “12345”).
- MPN: Manufacturer Part Number (e.g., “MPN123”).
- Pricing: USD only (e.g., “$599.99”).
- Required Field: Quantity ensures accurate inventory.
-
Error Scenario: If Quantity is missing, imports may fail:
Cannot invoke "java.lang.Integer.intValue()" because the return value of "GunbrokerProductDto.getQuantity()" is null
- Fix: Verify Quantity data in GunBroker listings and ensure correct import settings.
- Custom Fields: Not imported.
- Variants/Options: Not supported.
- Client Pricing & Currency: Not supported; USD only.
- Multiple Warehouses: Not supported.
- Weights & Dimensions: Not imported.
- Import Fails: Verify GunBroker API credentials and connection.
-
API Endpoint Issues: Ensure
https://api.gunbroker.com/v1/
is accessible. -
Quantity Not Importing:
- Check Quantity data in GunBroker listings.
- Missing Quantity may cause:
Cannot invoke "java.lang.Integer.intValue()" because the return value of "GunbrokerProductDto.getQuantity()" is null
- Fix: Ensure valid Quantity data in GunBroker and review import settings.
- Category Misalignment: Verify category mappings between Fixpoint and GunBroker.
- SKU Mismatches: Confirm Master SKU field matches data.
- Contact Support: Reach out to Fixpoint or GunBroker support with error details.
- Date: As of 08:53 PM -04, May 22, 2025, this integration is operational.
- Master SKU: Use SKU for reliable linking.
- Quantity: Must be valid to avoid NPE errors.
- Categories: Align with GunBroker IDs for accuracy.
Sync & Link Listings
- Sync price, quantity, and status (PQS) updates between Fixpoint and GunBroker.
- Link Fixpoint listings to GunBroker using SKU, UPC, or GTIN (e.g., SKU “GB12345”).
- Align Fixpoint categories with GunBroker’s structure (e.g., “Ammo” to “Centerfire Handgun Rounds”).
- Automatically delist products when quantity reaches zero, with relisting options.
- 1 Retrieve Listings: Fetches active listings from Fixpoint.
- 2 Delist Unavailable Products: Marks unavailable products for delisting on GunBroker.
- 3 Update Item IDs: Assigns new item IDs for GunBroker listings not in Fixpoint.
- 4 Handle Quantity Changes: Updates item IDs when quantity is sold (e.g., quantity “5” to “0”).
- 5 Queue Updates: Queues price (e.g., “$599.99”) and quantity updates.
- 6 Sync Data: Sends updates via PUT requests to GunBroker.
- 7 Delist Out-of-Stock: Delists zero-quantity listings.
- 8 Link Listings: Links by SKU, UPC, or GTIN based on priority.
- Linking Priority: Set order (e.g., SKU, UPC, GTIN) for matching listings.
- Category Alignment: Map Fixpoint categories to GunBroker IDs (e.g., “12345” to “Ammo”).
- Zero Quantity Handling: Delist products at zero quantity; relist by updating stock.
- Listing Type: Sync all, Fixed Price, or Auction listings.
- Scheduling: Run manually or schedule (e.g., daily at 6 AM UTC).
- Mapping Template: Define field mappings for syncing.
- 1 Add the Integration: In Integrations, select GunBroker and “Sync Listings.”
- 2 Connect to GunBroker: Use existing or new API credentials.
- 3 Configure Settings: Set linking priority, align categories, configure zero quantity handling, and enable scheduling.
- 4 Create a Mapping Template: Map fields like Quantity to GunBroker’s Inventory Level.
- 5 Run the Integration: Start manually or on schedule.
- Add stock in Fixpoint (e.g., quantity “5”).
- Run sync to update GunBroker.
- Listing is relisted with new quantity.
- Screen labeled “Mapping” with template, rule, and product builder options.
- Buttons: Delete, Save.
- Sections: From Value (Fixpoint fields), To GunBroker Variant Field.
- Don’t Map: Ignore the field.
- Set To Empty: Clear the field.
- Field: Map a Fixpoint field (e.g., Quantity).
- Value: Set a constant value.
- Mapping Set: Apply a predefined transformation.
- Required Fields: SKU, Quantity for syncing.
- Required Field: Quantity is mandatory for syncing.
-
Error Scenario: If Quantity is not mapped and the product is not Delisted, sync may fail:
Cannot invoke "java.lang.Integer.intValue()" because the return value of "GunbrokerProductDto.getQuantity()" is null
- Delisted Exception: If Quantity is unmapped but the product is Delisted, delisting proceeds correctly.
- Price Dependency: Mapping Price alone is insufficient; Quantity is required.
- Fix: Go to Sales Channel > GunBroker > Templates > Sync Listings > Field Mapping, ensure Quantity and Price are mapped, save, and re-run the sync job.
- Listing Variant: Quantity, List Price, MAP, MSRP, Estimated Cost, Estimated Dropship Fee, Estimated Shipping Cost.
Fixpoint Field | Maps To | Example | Purpose | Status |
---|---|---|---|---|
SKU | GunBroker Variant - SKU | GB12345 | Links listings | Required |
List Price | GunBroker Variant - Fixed Price | $599.99 | Updates price | Enabled |
Quantity | GunBroker Variant - Quantity | 5 | Updates inventory | Required |
UPC | GunBroker Variant - UPC | 012345678905 | Alternate identifier | Optional |
GTIN | GunBroker Variant - GTIN | 012345678905 | Alternate identifier | Optional |
- Connection Issues: Verify GunBroker API credentials and connection.
- Linking Fails: Ensure linking priority (e.g., SKU) matches data in Fixpoint and GunBroker.
-
Quantity Sync Issues:
- Check if Quantity is mapped in the template.
- Unmapped Quantity may cause:
Cannot invoke "java.lang.Integer.intValue()" because the return value of "GunbrokerProductDto.getQuantity()" is null
- Fix: Go to Sales Channel > GunBroker > Templates > Sync Listings > Field Mapping, ensure Quantity and Price are mapped, save, and re-run sync.
- Category Misalignment: Verify category mappings (e.g., “Ammo” to “12345”).
- Delisting Issues: Ensure zero-quantity handling is configured correctly.
- Contact Support: Reach out to Fixpoint or GunBroker support with error details.
- Date: As of 08:55 PM -04, May 22, 2025, this integration is operational.
- Quantity: Must be mapped to avoid NPE errors.
- Linking: Prioritize SKU for best results.
- Delisting: Automatic at zero quantity; relist by adding stock.
Publish Listings
- Create new product listings on GunBroker from Fixpoint.
- Map product data to GunBroker fields using a mapping template.
- Ensure accurate category mapping with numeric Category IDs (e.g., “3018” for Pistol Ammunition).
- Prevent publishing listings with missing or zero cost/list price to avoid low pricing errors.
- 1 Category Mapping: Maps Fixpoint categories to GunBroker’s numeric Category IDs (e.g., “3018” for Pistol Ammunition).
- 2 Mapping Data: Maps fields like Title to Name, SKU to SKU (e.g., “AMMO-001”), with a rule setting quantity to 0 if cost or list price is missing.
-
3 Publishing Products: Publishes via POST request with parameters like
ItemSKU=AMMO-001&SellerName=YourSellerName
. - 4 Handling Zero Quantity: Ends listings at quantity 0; republish by updating quantity (e.g., “5”) and syncing.
- 5 Running the Integration: Runs manually or on a schedule (e.g., daily).
Category Path | Category ID |
---|---|
All > Air Guns > Air Gun Accessories | 3052 |
All > Air Guns > Air Pistols | 3049 |
All > Ammunition > Pistol Ammunition | 3018 |
All > Ammunition > Reloading > Reloading Equipment | 3015 |
All > Ammunition > Ammo Storage | 3053 |
- 1 Add the Integration: In Integrations, select GunBroker and “Publish Listings.”
- 2 Connect to GunBroker: Use existing or new API credentials.
- 3 Configure Settings: Set category mappings, create a mapping template, and configure scheduling (e.g., daily).
- 4 Run the Integration: Start manually or on schedule.
- Auto relist defaults to No.
- Serial numbers created but not updated via overwriting.
- Categories require numeric IDs.
- No variations/options support.
- Screen labeled “Publish Listings” with template naming (e.g., “Publish Listings 1”).
- Buttons: Delete, Duplicate, Save.
- Sections: From Value (Fixpoint fields), To GunBroker Product Field.
- Don’t Map: Ignore the field.
- Set To Empty: Clear the field.
- Field: Map a Fixpoint field (e.g., Title).
- Value: Set a constant value.
- Mapping Set: Apply a predefined transformation.
- Rules: Use conditional logic (e.g., set quantity to 0 if cost is 0).
- Required Fields: Name, SKU, Category, Quantity.
- Required Field: Quantity is mandatory for publishing.
-
Error Scenario: If Quantity is not mapped, publishing may fail:
Cannot invoke "java.lang.Integer.intValue()" because the return value of "GunbrokerProductDto.getQuantity()" is null
- Default Rule: Sets quantity to 0 if cost or list price is 0 or missing, ending the listing to prevent low pricing errors.
- Fix: Go to Sales Channel > GunBroker > Templates > Publish Listings > Field Mapping, ensure Quantity and Price are mapped, save, and re-run publishing.
- Listing Parent: Attribute, Brand, Category 1, Category 2, Category 3, Custom Field, Description, Image, Parent SKU, Title.
- Listing Variant: ASIN, Custom Field, Description, Estimated Cost, Estimated Dropship Fee, Estimated Shipping Cost, GTIN, Image, List Price, MAP, MPN, MSRP, Master SKU, Quantity, SKU, Title, UPC, Weight.
Fixpoint Field | Maps To | Example | Purpose | Status |
---|---|---|---|---|
Title | GunBroker - Name | 9mm Pistol Ammunition | Listing name | Required |
Parent SKU | GunBroker - SKU | AMMO-001 | Identifies listing | Required |
Category 1 | GunBroker - Category | 3018 (Pistol Ammunition) | Sets category | Required |
Quantity | GunBroker - Quantity | 5 | Sets inventory | Required |
List Price | GunBroker - Price | $29.99 | Sets price | Enabled |
Description | GunBroker - Description | 50 rounds per box | Describes listing | Enabled |
Image | GunBroker - Images | URL list | Adds images | Enabled |
UPC | GunBroker - UPC | 123456789012 | Alternate identifier | Optional |
Weight | GunBroker - Weight | 2.5 | Item characteristic | Optional |
- Category Errors: Ensure Category 1 maps to a valid numeric ID from the spreadsheet.
- Duplicate Listings: Verify SKUs match between Fixpoint and GunBroker (e.g., “AMMO-001”).
-
Quantity Not Publishing:
- Check if Quantity is mapped in the template.
- Unmapped Quantity may cause:
Cannot invoke "java.lang.Integer.intValue()" because the return value of "GunbrokerProductDto.getQuantity()" is null
- Fix: Go to Sales Channel > GunBroker > Templates > Publish Listings > Field Mapping, ensure Quantity and Price are mapped, save, and re-run publishing.
- Zero Quantity Listings: If cost or list price is 0, update both in Fixpoint and re-sync.
- Image Issues: Ensure images meet GunBroker’s size requirements.
- Contact Support: Reach out to Fixpoint or GunBroker support with error details.
- Date: As of 09:00 PM -04, May 22, 2025, this integration is operational.
- Quantity: Must be mapped to avoid NPE errors.
- Categories: Use numeric IDs for mapping.
- Auto Relist: Defaults to No.
Order Operations
Flxpoint imports orders from eBay into your system, automating order processing, tracking updates, and inventory adjustments. This streamlines fulfillment and ensures efficient handling of eBay transactions.
Get Orders
- Import new orders with payment status, shipping details, and customer data (e.g., order ID “ORD123”).
- Map GunBroker shipping methods (e.g., “Standard”) to Fixpoint shipping policies.
- Handle FFL-compliant orders with additional checks.
- Import orders in USD with itemized details (e.g., SKU “AMMO-001”, quantity “5”).
-
1 Fetch Orders: Retrieves orders in batches of 250 via
/orders
. - 2 Get Order Details: Fetches status, FFL status, and timestamps.
-
3 Retrieve Line Items: Gets SKUs and quantities via
/items/{itemId}
. -
4 Fetch FFL Details: Retrieves FFL data via
/ffls/{fflId}
for compliant orders. - 5 Multi-Status Handling: Processes statuses (e.g., Payment Pending) separately.
- 6 Iterate and Import: Imports orders based on selected statuses.
- Order Status Selection: Choose statuses (e.g., Payment Pending, Awaiting Shipment).
- Shipping Mappings: Map GunBroker methods (e.g., “Standard”) to Fixpoint policies.
- FFL Handling: Enable FFL checks and set rules (e.g., flag “Rifles”).
- PII Retention: Set periods (e.g., 30 days after shipment).
- Time Frame: Fetch orders from a period (e.g., last 14 days).
- Scheduling: Run manually or schedule (e.g., daily at 6 AM UTC).
- Mapping Template: Map GunBroker fields to Fixpoint fields.
- 1 Add the Integration: In Integrations, select GunBroker and “Get Orders.”
- 2 Connect to GunBroker: Use existing or new API credentials.
- 3 Configure Settings: Select statuses, map shipping methods, set FFL rules, configure PII retention, and define time frame.
- 4 Create a Mapping Template: Map fields like Line Item - SKU to Fixpoint SKU.
- 5 Run the Integration: Start manually or schedule.
- “Standard” to Fixpoint “Standard” policy.
- “Priority” to Fixpoint “Priority” policy.
- FFL Rules: Set rules in source settings (e.g., flag “Rifles”).
- FFL Orders: Include FFL dealer info; “Needs Attention” orders require manual approval.
- Order & Payment Statuses: Saved in channel invoice section.
- Order Acknowledgment: Not supported.
- Order Receipt/Invoice & Currency: USD only.
- Shipping Selection: Mapped in shipping management.
- Custom Fields: Not supported.
- PII Restrictions: Configurable retention periods.
- Digital Items/Donations: Not supported.
- Weight & Dimensions: Not supported.
- Batch Processing: 250 orders per batch.
- Screen labeled “Get Orders” with template naming (e.g., “Get Orders 4”).
- Buttons: Delete, Duplicate, Save.
- Sections: From Value (GunBroker fields), To Fixpoint Field.
- Don’t Map: Ignore the field.
- Set To Empty: Clear the field.
- Field: Map a GunBroker field (e.g., Line Item - Quantity).
- Value: Set a constant value.
- Mapping Set: Apply a transformation.
- Rules: Use conditional logic.
- Required Fields: Order ID, SKU, Quantity.
- Required Field: Quantity is critical for order accuracy.
-
Error Scenario: If Quantity is not mapped, imports may fail:
Cannot invoke "java.lang.Integer.intValue()" because the return value of "GunbrokerProductDto.getQuantity()" is null
- Fix: Go to Sales Channel > GunBroker > Templates > Get Orders > Field Mapping, ensure Line Item - Quantity is mapped, save, and re-run import.
- Billing Address: City, Company, Country, Email, First Name, Last Name, Phone, State, Street Address 1, Street Address 2, Zip.
- Line Item: SKU, Quantity, Price Ex Tax, Price Inc Tax, Name, UPC.
- Order: Order ID, Payment Status, Date Created, Shipping Cost, Total Ex Tax, Total Inc Tax.
- Shipping Address: City, Country, First Name, Last Name, Phone, Shipping Method, State, Street Address 1, Street Address 2, Zip.
GunBroker Field | Maps To | Example | Purpose | Status |
---|---|---|---|---|
Line Item - SKU | Fixpoint - SKU | AMMO-001 | Identifies product | Required |
Line Item - Quantity | Fixpoint - Quantity | 5 | Sets ordered units | Required |
Order - Order ID | Fixpoint - Order ID | ORD123 | Identifies order | Required |
Shipping Address - State | Fixpoint - State | CA | Shipping address | Enabled |
Shipping Address - Shipping Method | Fixpoint - Shipping Method | Standard | Shipping policy | Enabled |
Order - Total Inc Tax | Fixpoint - Total | $34.99 | Order total | Enabled |
-
Connection Issues: Verify GunBroker API credentials and ensure endpoints (e.g.,
/orders
,/ffls/{fflId}
) are accessible. - Missing Orders: Check selected order statuses and time frame (e.g., last 14 days).
-
Quantity Not Importing:
- Ensure Line Item - Quantity is mapped in the template.
- Unmapped Quantity may cause:
Cannot invoke "java.lang.Integer.intValue()" because the return value of "GunbrokerProductDto.getQuantity()" is null
- Fix: Go to Sales Channel > GunBroker > Templates > Get Orders > Field Mapping, ensure Line Item - Quantity is mapped, save, and re-run import.
- FFL Issues: Verify FFL rules in source settings and check “Needs Attention” orders for manual approval.
- Shipping Mismatches: Confirm GunBroker shipping methods map to Fixpoint policies.
- Contact Support: Reach out to Fixpoint or GunBroker support with error details.
- Date: As of 09:04 PM -04, May 22, 2025, this integration is operational.
- Quantity: Must be mapped to avoid NPE errors.
- FFL Handling: Configure rules for compliance.
- Batch Processing: Imports 250 orders per batch.
Sync Orders
- Push shipment updates, including tracking numbers (e.g., “1Z9999W999999999”) and carriers (e.g., “FedEx”), to GunBroker.
- Update order status to “Shipped” on GunBroker (e.g., for order ID “ORD123”).
- Keep buyers informed about their order status, enhancing satisfaction.
- 1 Fetch Orders: Retrieves orders from Fixpoint using DMX-Core (V1) or Fixpoint API (V2).
- 2 Verify FFL Status: Skips orders with FFL items unless marked “FFL Received.”
- 3 Check Shipment Status: Ensures the entire order is shipped (partial shipments not supported).
-
4 Sync Shipment: Pushes updates via PUT to
/orders/{orderId}/shipments
with tracking and carrier data. -
5 Update Status: Sets “Shipped” status via PUT to
/orders/{orderId}/flags
.
- Mapping Template: Map Fixpoint shipment fields to GunBroker fields (e.g., Tracking Number).
- Scheduling: Run manually or schedule (e.g., daily at 6 AM UTC).
- 1 Add the Integration: In Integrations, select GunBroker and “Sync Orders.”
- 2 Connect to GunBroker: Use existing or new API credentials.
- 3 Configure Settings: No additional settings required.
- 4 Create a Mapping Template: Map fields like Shipment - Tracking Number to GunBroker’s Tracking Number.
- 5 Run the Integration: Start manually or schedule.
- Platform "Notify Customer" Flow: Not supported.
- Partial Order Shipments: Not supported.
- Partial Order Item Shipments: Not supported.
- Post-Shipment Status Updates: Updates to “Shipped” on GunBroker.
- Manual Order Item Limitations: Manually added items don’t sync; complete manual orders can sync.
- Limitation: Only fully shipped orders sync; partial shipments are not supported.
- Screen labeled “Sync Orders” with template naming (e.g., “Sync Orders 1”).
- Buttons: Delete, Duplicate, Save.
- Sections: From Value (Fixpoint fields), To GunBroker Shipment Field.
- Don’t Map: Ignore the field.
- Set To Empty: Clear the field.
- Field: Map a Fixpoint field (e.g., Shipment - Tracking Number).
- Value: Set a constant value.
- Mapping Set: Apply a transformation.
- Rules: Use conditional logic.
- Required Fields: Tracking Number, Shipping Provider.
- Critical Data: Quantity ensures accurate shipment syncing.
-
Error Scenario: If Quantity is missing in Get Orders, syncing may fail:
Cannot invoke "java.lang.Integer.intValue()" because the return value of "GunbrokerProductDto.getQuantity()" is null
- Fix: Go to Sales Channel > GunBroker > Templates > Get Orders > Field Mapping, ensure Line Item - Quantity is mapped, save, and re-run the import and sync jobs.
- Shipment: Carrier, Fulfillment Request Number, Method, Note, Shipped At, Shipping Cost, Tracking Number, Tracking URL.
Fixpoint Field | Maps To | Example | Purpose | Status |
---|---|---|---|---|
Shipment - Carrier | GunBroker - Shipping Provider | FedEx | Specifies carrier | Required |
Shipment - Tracking Number | GunBroker - Tracking Number | 1Z9999W999999999 | Tracks shipment | Required |
Shipment - Note | GunBroker - Comments | Handle with care | Adds notes | Optional |
Shipment - Shipping Cost | GunBroker - Merchant Shipping Cost | $5.99 | Shipping cost | Optional |
Shipment - Tracking URL | GunBroker - Tracking Link | https://fedex.com/track | Tracking URL | Optional |
-
Connection Issues: Verify GunBroker API credentials and ensure endpoints (e.g.,
/orders/{orderId}/shipments
) are accessible. - FFL Errors: Ensure FFL items are marked “FFL Received”; check order status in Fixpoint.
-
Quantity Sync Issues:
- Verify Line Item - Quantity is mapped in the Get Orders template.
- Unmapped Quantity may cause:
Cannot invoke "java.lang.Integer.intValue()" because the return value of "GunbrokerProductDto.getQuantity()" is null
- Fix: Go to Sales Channel > GunBroker > Templates > Get Orders > Field Mapping, ensure Line Item - Quantity is mapped, save, and re-run import and sync.
- Partial Shipment Errors: Ensure the entire order is shipped, as partial shipments are not supported.
- Mapping Errors: Confirm Shipment - Tracking Number and Carrier are mapped correctly.
- Contact Support: Reach out to Fixpoint or GunBroker support with error details.
- Date: As of 09:06 PM -04, May 22, 2025, this integration is operational.
- Quantity: Must be mapped in Get Orders to avoid NPE errors.
- FFL: Requires “FFL Received” for FFL items.
- Shipments: Only full shipments sync.