After Import, Sales are Linked to the Wrong Item

Symptom

After an import from eBay, some sales are created showing the wrong picture and are linked to the wrong item.

Background

When SixBit imports items from eBay, it will create items for each listing you have running. If you have multiple listings running for the same item, SixBit will attempt to match those duplicate listings to an existing item so that it does not create duplicate items. It does this by first looking at the "custom label" field on eBay. The custom label field on eBay is usually used as a unique identifier (SKU). By default, we save the custom label field in the SKU field. If multiple listings have the same custom label (SKU) value, then we will assume that they are all created from the same item.

Cause

Sales will be linked to incorrect items when the "custom label" field on eBay is not a unique identifier, yet it is mapped to SKU in the SixBit options window.

Solution

If your custom labels on eBay are not unique, you should go to Options | Refresh in SixBit and map the custom label field to a field other than the SKU field. Once you do that, future items won't import correctly.

To fix incorrect items currently, simply delete the incorrect items from the Sell Items mode, make the change to Options|Refresh described above and then do a reimport from eBay.

  • Importing Orders, Order Import Issue, Sales Linked Incorrectly, Importing Exporting Backing up Data
  • 16 Users Found This Useful
Was this answer helpful?

Related Articles

"It appears that the database was not initially populated with data" error message

Symptoms:        - Error message pops up in SixBit stating the database is not populated....

Creating a SQL Server Database with Blackthorne Basic

Background:To import a Blackthorne database into SixBit, it must be a SQL Server database.  This...

Import from CSV is not Importing Any Items

Symptom:After importing from CSV, the items do not appear anywhere in SixBit. Cause:   The...

Importing an Access Database from Blackthorne

Overview: Blackthorne users can use either an Access database or a SQL Server database. SixBit...

Importing From Multiple eCommerce Sites Handling

A big portion of setting up SixBit to work with multiple eCommerce sites involves defining or...