Excel File Sorted Import of Products

Highlighted
New Member
5 0 0

We are going to be carrying roughly 24,000 products at launch when our forthcoming ecommerce store opens.  We are 100% dropship, and receive product data through both API feeds and Excel documents.

The problem we have is that many of our suppliers sell not just products themed to our specific niche (animal collectibles) but to a wide variety of niches not at all related to what we will be selling on our store.  In other words, for example, a supplier might offer 10,000 products, but we only plan to carry 1,000 because only those items are related to animals and could be considered an animal collectible (i.e., a Wolf lamp or a Golden Retriever comforter).

Our question is this:

1.  How do we configure our Excel imports to exclude all the items we DON'T want, especially if animals are not a unique category in the dropshipper's feed?

2.  Does anyone have a recommendation for an app that could streamline this process for us? 

This is a tough thing for us, as we have so many great suppliers, but only need a percentage of their overall inventory.

Many thanks for any assistance or knowledge you're willing to share with us!

0 Likes
Highlighted
Shopify Partner
2294 116 353

Richard Starr, It's best to find a platform agnostic workflow first for data, especially if this is your first foray.

This is a pre shopify issue, conversly if the data needed to be exported out of shopify it would have more solutions available.

So unless your ready to invest in a custom app built that parses your data by conditions-X, let's focus on tools you can use. 

For brevity's sake going to assume you've gotten the columns from the droppshipper transformed to the columns shopify needs for importing. But you just need to prune the unwanted stuff. 

The issues:

  How do we configure our Excel imports to exclude all the items we DON'T want, especially if animals are not a unique category in the dropshipper's feed?

You must find a logical rule that applies to every entry that is item type you want, after all if there is no rule by which to identify an animal item how would an app help?

Once you figure that out we can get you going. The typical answer is just use a calculated columnexcel filter and export unfiltered fields.If you don't have excel a free google docs account will give you access to spreadsheet software.

Problem Solved? ✔️Accept and ? Like the solution so you can help others.
Buy me a coffee ☕ paypal.me/paulnewton or donate to eff.org
Confused? Busy? Buy a custom solution paull.newton+shopifyforum@gmail.com
0 Likes
Highlighted
Shopify Partner
292 5 40

Hi!

You could use the Bulk Import Export Update with Excel app, which basically is built for streamlining the imports, exports and updates of large volumes of Products, Collections and Customers (and more is coming).

Yoo!

Maris

 

Excelify.io | Bulk Import Export Update Migrate | https://excelify.io
0 Likes