Educator's Resource as a Source
Summary
Educator's Resource is a supplier of educational materials, school supplies, and classroom resources. The connection method depends on the operation: Get Inventory (Primary) connects to ercontent.com with no credentials required, while Get Inventory (Secondary), Send Orders, and Get Shipments use FTP - Secondary on ercontent.com, and the two order operations over EDI (850/856) on edi.eduresource.com, which requires a pre-established EDI account with Educator's Resource.
In Flxpoint go to Sources, add or open your Educator's Resource source, then under Integrations pick the process and click Start Creating Integrations. Get Inventory (Primary), Send Orders, and Get Shipments use hard-coded credentials behind the scenes - no details are required. For Get Inventory (Secondary), enter your FTP details in the New Educators Resource Connection form, then Test Connection → Save Connection.
ercontent.com with the connection preconfigured. Skip the FTP fields and proceed straight to Configure Settings.ercontent.com. Send Orders and Get Shipments use a hard-coded EDI connection and don't require this field.21, or as provided by Educator's Resource.Get Inventory (Primary) needs no credentials - the connection to ercontent.com is preconfigured
Primary connects to ercontent.com without a username or password and automatically downloads three files: ERQTYBN.csv (stock), ER_Content.csv (product details), and ERBritPr.txt (default pricing). If any of the three files is missing or empty the import fails with an error. Product images download only in the production environment (not sandbox) and are stored in /Assets/Original_Images and /Assets/Additional_Images.
Send Orders and Get Shipments require a pre-established EDI account with Educator's Resource
Order operations exchange EDI 850 (Send Orders) and EDI 856 (Get Shipments) files over FTP on edi.eduresource.com. You must have an EDI account set up before they work - if you don't, contact Flxpoint Support to coordinate setup with ER. You also configure your Sender/Receiver Qualifier and ID (e.g., ID 630751670) and ER's corresponding values, provided during EDI setup.
Get Inventory (Secondary) reads ERQTY.csv - not ERQTYBN.csv
Secondary pulls quantity from ERQTY.csv in Option A > Daily Files, a different file than Primary uses. Educator's Resource previously used ERQTYBN.csv for Secondary but switched back to ERQTY.csv to improve sales performance. You can override the defaults with custom FTP price and quantity files if your account has account-specific pricing.
Custom pricing needs an account-specific file in the root FTP folder
If Educator's Resource provided account-specific pricing (e.g., E10_D.csv), configure it in Get Inventory (Primary) or (Secondary) with your Server Name, Username, and Password. The custom file overrides the default ERBritPr.txt pricing. The password follows the pattern letter + number + "D" (e.g., E10D), and the file must sit in the root folder (/) on the server.
| Educator's Resource Field | Maps To – Notes |
|---|---|
| PartID (Product File) | → Parent SKU. Unique identifier for each product; needs column mapping - no direct copy. |
| Barcode (ER_Content.csv) | → UPC. The product's Universal Product Code. |
| Product Title (ER_Content.csv) | → Title. Official product name from Educator's Resource. |
| Suggested Long Description / Bullet Points 1-6 | → Description. Long/short descriptions from the Content file. |
| Cost (ERBritPr.txt) | → Cost. Default product cost. MAP and MSRP are also available from the Product file. |
| Available (ERQTYBN.csv) | → Quantity. On-hand stock from the inventory file. |
| Weight (ER_Content.csv) | → Weight. Set Weight Unit with a Value (e.g., "pound") since ER doesn't supply it. |
| Length / Width / Height (ER_Content.csv) | → Dimensions. Numeric measurements per side. |
| Large Image Link (ER_Content.csv) | → All Images. Primary product image; images download only in production. |
| Brand / Manufacturer, Web Category / Web Product Type | → Brand and Category. Also available: Age, Color, Material, Group, ProductSeries for attributes/custom fields. |
ercontent.com; no connection credentials are entered. In Configure Settings, choose whether missing products are archived or set to 0 quantity.| Educator's Resource Field | Maps To – Notes |
|---|---|
| Part Id (Product File) | → SKU. Unique product identifier; use Direct Copy. |
| Available (ERQTY.csv) | → Quantity. Default file is ERQTY.csv in Option A > Daily Files; a custom FTP Quantity File overrides it. |
| Cost (Product File) | → Cost. Or map to Price from the User Price File when a custom price file is configured. |
| MAP (Product File) | → MAP. Or MAP Price from the User Price File if custom pricing is used. |
| MSRP (Product File) | → MSRP. Or Retail Price from the User Price File if custom pricing is used. |
ercontent.com via FTP; enable Archive/Un-Archive Inventory to zero out items dropped from the feed.| Fulfillment Field | Maps From – Notes |
|---|---|
| Product SKU | ← your SKU (Direct Copy) so ER can identify the product. |
| Quantity | ← your Quantity (Direct Copy) - units to ship. |
| UPC | ← your UPC (Direct Copy) to help ER match the item. |
| Product Description | ← your Product Description. Adds context to the order line. |
| Unit Measurement Code | Direct Copy, or set a Value such as EA (each). |
| Cost | Optional - Direct Copy for order verification, or Don't Map if not required. |
| Shipping Method | Use a Mapping Set to convert your method to ER's code (e.g., "3-day" → ER01). |
/outbound/ folder on edi.eduresource.com; ER retrieves them from /inbound/. Optional settings include Hold for X Hours and Send During Business Hours. "Supplier FTP URL" is rarely used - leave as Don't Map.| Educator's Resource Field | Maps To – Notes |
|---|---|
| SKU (Shipment Item) | → SKU. Matches the shipped item to your order records; use Direct Copy. |
| UPC Number (UP) | → UPC. Verifies product identity; use Direct Copy. |
/outbound/ folder on edi.eduresource.com and moves processed files to /inbound/. Additional fields may be present depending on the 856 format ER sends for your account.ercontent.com: ERQTYBN.csv, ER_Content.csv, and ERBritPr.txt. If any is absent or empty, Primary cannot run - this depends on Educator's Resource publishing their data files on schedule. If files are consistently missing, contact ER to confirm their file generation is running correctly.edi.eduresource.com and that your Sender/Receiver Qualifier and ID values are entered correctly. If you don't yet have an EDI account with ER, contact Flxpoint Support to establish the connection on your behalf.E10_D.csv) isn't overriding the default ERBritPr.txt pricing, verify: (1) the file is named correctly and placed in the root folder (/) on the FTP server; (2) Server Name, Username, and Password are entered in the custom pricing settings; (3) the password follows the letter + number + "D" pattern (e.g., E10D). A misconfigured file silently falls back to the default Product File pricing.What files does Get Inventory (Primary) download and what does each contain?▸
ercontent.com; if any is missing the job errors and nothing imports. Images live in /Assets/Original_Images (primary) and /Assets/Additional_Images and download only in the production environment.What are the supported shipping method codes for Send Orders?▸
ER01 (3-day), ER02 (Best Effort 2nd Day), ER03 (Expedited), UP06 (Guaranteed 2nd-Day Delivery), and ERST (Standard).How do I get marketplace-specific quantities (Amazon, Walmart) from Educator's Resource?▸
ERQTY_AMZBN.csv, with quantities optimized for Amazon, Walmart, eBay, and Jet. To use these instead of the standard ERQTYBN.csv/ERQTY.csv quantities, configure a custom FTP Quantity File override in Get Inventory (Secondary) settings pointing to this file.What fields does Get Shipments retrieve from Educator's Resource?▸
/outbound/ folder on edi.eduresource.com. The available shipment item fields are SKU and UPC Number (UP); processed files are moved to /inbound/. Additional fields may be present depending on the 856 format ER sends for your account.What are the EDI folder paths for Send Orders and Get Shipments?▸
/outbound/ and retrieved by Educator's Resource from /inbound/. For Get Shipments: EDI 856 (shipment confirmation) files are placed by ER in /outbound/ and retrieved by Flxpoint, then moved to /inbound/ after processing. Both use FTP port 21 on edi.eduresource.com.