SEMA Data as a Source
Summary
SEMA Data is a pre-built automotive aftermarket product-data source in Flxpoint. It connects over FTP, SFTP, or FTPS and runs Get Inventory (Primary), importing part numbers, fitment attributes, and images, plus pricing and quantity if your SEMA export template includes them. SEMA Data is a catalog/data feed only; order operations are not part of this integration.
SEMA Data connects over FTP, SFTP, or FTPS, using the protocol your SEMA export is provisioned for. Add a SEMA Data source, start configuring Get Inventory Primary, and when Flxpoint prompts you click + New Connection, enter the values, then Test Connection → Save Connection.
| Field | What to enter |
|---|---|
ProtocolRequired | FTP, SFTP, or FTPS, as provisioned for your SEMA export. |
HostRequired | The FTP/SFTP server where your SEMA Global/Custom Export is delivered. |
PortRequired | The connection port. |
UserRequired | Your FTP/SFTP username. |
PasswordRequired | Your FTP/SFTP password. |
Part Number, not PartNumber).Use Pipe Delimited, not comma
Configure the SEMA Custom Export as Pipe Delimited. Comma-delimited files are not recommended and cause parsing errors.
Stagger the export and the import
Schedule the SEMA Global Export first, then run Flxpoint Get Inventory Primary about 30 minutes later so SEMA's data has finalized before the pull.
Column names must match exactly
Flxpoint expects exact column names (for example, "Part Number", not "PartNumber"). Mislabeled columns break the import.
Files must arrive as zip archives
Flxpoint opens every file it downloads as a zip (or rar) archive and reads the pipe-delimited .txt brand files inside it. A plain .txt file left on the server is not read. By default only files updated in the last 5 days are downloaded.
Imports SEMA's part, fitment, and image data from your export template.
| Field | Maps To: Notes |
|---|---|
| Product Attributes (name:value pairs separated by ;) | → Product → Attributes. Each attribute is a name and a value written as name:value, and attributes are separated by a semicolon (;). A pair that does not have exactly one colon is skipped. |
| Primary | → Product / Variant → Images. Added as the first image. |
| Additional Image | → Product / Variant → Images. Added as an additional image. |
| Logo | → Product / Variant → Images. Added as an additional image. |
| Part Number and the other columns of your export template | → Product / Variant. Mapped field-by-field from your SEMA Custom Export column names: exact column names are required (for example, "Part Number"). The SEMA export has no price, cost or quantity-on-hand columns. |
Missing or mislabeled columns in the feed
Connection issues pulling the file
SKUs are archived despite being present in the SEMA feed?
Which delimiter should the SEMA export use?
When should the Flxpoint import run?
Can SEMA deliver more than one file?
.txt brand files. Each downloaded file must be a .zip, or a rar archive. Plain text files are not read.