Connecting or importing your inventory feed into OfferUp

Use this guide to bring products from Lightspeed Retail into OfferUp for Business. You can either connect your Lightspeed account, which brings in products with their photos, or upload an export file from Lightspeed. Both paths end the same way: your items arrive as drafts on the Create Listings page, ready for you to review and post.

Before you start

  • Use a computer. Import isn’t available on phones.
  • Sign in to your OfferUp Business Portal and open Import in the left-hand menu.
  • Each item needs five things from Lightspeed: an item ID, a title, a description, a price, and at least one photo. OfferUp fills in the rest, such as category and condition.

Import your inventory, step 1

Select the Lightspeed Retail tile. You’ll see two options side by side: Connect Lightspeed and Export from Lightspeed.

Option 1: Connect your Lightspeed account

Connecting is the fastest way in, and it brings your product photos along. You sign in on Lightspeed’s own site, so OfferUp never sees your Lightspeed username or password. OfferUp only reads your catalog; it never changes anything in Lightspeed, and you can revoke its access from Lightspeed at any time.

1. Sign in with Lightspeed

In the Connect Lightspeed panel, click Sign in with Lightspeed. A Lightspeed window opens.

Connect Lightspeed panel

Confirm your store URL and click Next.

Lightspeed sign-in

Lightspeed asks you to approve access. Click Approve installation.

Lightspeed approval screen

About this screen: Lightspeed labels each permission “Manage”, but OfferUp only reads your products, inventory and store locations. Lightspeed may also say this app isn’t approved by Lightspeed. That only means OfferUp isn’t in Lightspeed’s App Marketplace yet, which is expected during this pilot phase. Your connection is secure and OfferUp only reads your catalog.

The window closes and OfferUp shows Connected to Lightspeed Retail, with the store it found. Click Continue.

Connected to Lightspeed Retail

2. Choose which products to bring in

Narrow your catalog with the filters, then click Apply filters. Nothing is loaded from Lightspeed until you do. You can filter by date added, category, brand, tag, and price.

Catalog filters

Category filter

Your products appear in a list, and every one is ticked. Untick any you don’t want to import. Each size or colour of a product appears as its own row with its own photo.

Products found

Large catalogs load 500 products at a time. When you finish a batch, you can move on to the next one, so you can bring in your whole catalog 500 at a time.

3. Check the listing preview and the shared settings

The Listing preview shows how the first product you selected will look on OfferUp. The title, description, price and photo come from Lightspeed. The rest of the items are built the same way.

Listing preview

Filled in automatically lists what OfferUp adds: the category, based on each item’s name; the condition; the pickup location; and the photos, which OfferUp copies and hosts.

Filled in automatically

Under Change for all items, choose the condition that fits most of the items, and set the pickup location. Click Change to set the location by ZIP code or your current location. You can still edit each listing after the import.

Change for all items

Set location

4. Import

Click Import N items. Items are posted to your drafts one at a time. Keep the tab open until it finishes; if you close it, the items already imported stay in your drafts.

Importing your inventory

When it says Import complete, click View drafts.

Import complete

Option 2: Upload an export file

If you’d rather not connect your account, export your products from Lightspeed and upload the file. The Export from Lightspeed panel has a tab for each Lightspeed version, X-Series (Retail POS) and R-Series (Retail). Select yours to see its steps. Both are covered below.

1. Export from Lightspeed

X-Series (Retail POS): in Retail POS, open Catalog › Products. Click Export List, then choose CSV, or XLSX if you have fewer than 5,000 products.

X-Series export steps

R-Series (Retail): in Lightspeed Retail, open Reports › Inventory › Inventory Detail. Set Shop to all and Status to “Available”, click Export, and choose CSV.

R-Series export steps

Photos: Lightspeed’s exports don’t include photo links. To import with photos, add a column named image_url with a link to each item’s photo. You can add more with image_url_2 through image_url_5. Without photo links, your items can still be imported. They’re saved as drafts on the Create Listings page, where you add a photo to each one before posting it (see “After the import: review and post your drafts”).

2. Upload the file

Drop the file into Drop your export here, or click Choose a file. CSV and XLSX files up to 20 MB are accepted.

Drop your export here

3. Confirm what we read

OfferUp reads the file and tells you how many rows are ready to import and how many it had to skip, with the reason for each.

Import summary

Click See the rows to see exactly which ones were skipped and why.

Skipped rows

If some rows have no price, you can set one price for all of them under Price for rows with none, so they can be imported too.

Price for rows with none

Then choose the condition and pickup location under Change for all items, just like the connect path, and check the listing preview.

Change for all items

Condition options

If none of the items in your file has a photo link, OfferUp tells you and gives you three choices: connect your account instead, upload a file with photo links, or save everything as drafts and add photos on the Create Listings page.

No photo links in this file

4. Import

Click Import. When it’s done you’ll see how many items were imported, with any that need your attention.

Import complete

Import results

After the import: review and post your drafts

Imported items wait on the Create Listings page as drafts. Items marked Ready to post have everything they need. Items marked Incomplete need something added first, usually a photo or a category. Review them, then post individually or click Post all.

Create listings

Troubleshooting

“Some products can’t be imported”

Each skipped item shows a reason, such as no price, a price of zero, no item name, no photo, or archived in Lightspeed. Fix the item in Lightspeed, or in your file, and import again. For the file path, Price for rows with none can rescue rows that are only missing a price.

My items have no photos

Lightspeed exports don’t include photo links. Either connect your account instead, which brings photos in automatically, or add an image_url column to your file. If you connect and an item still has no photo, add one to that product, or to that size or colour, in Lightspeed and import it again.

I can’t import more than 200 items

Create Listings holds up to 200 drafts at a time. Post or delete some drafts to make room, then import the rest.

I see duplicate drafts

OfferUp remembers which products you’ve already imported, so they’re hidden the next time you import. That memory is kept in the browser you used. If you import from a different browser or computer, or after clearing your browser data, products you imported before can come in again as new drafts. Delete any duplicates from Create Listings before posting.

My products don’t load after I connect

Click Apply filters. OfferUp doesn’t load anything from Lightspeed until you do. If the list is empty, widen or clear your filters. If you’ve added products in Lightspeed since you last looked, click Check for new products.

Disconnecting OfferUp from Lightspeed

You can remove OfferUp’s access at any time from Lightspeed Retail (X-Series): open Apps › Installed apps, click the ⋮ menu next to OfferUp, and choose Uninstall. After that, OfferUp can no longer read your catalog. Items you’ve already imported stay in OfferUp, and you can reconnect from the Import page whenever you want to import again.

Was this article helpful?