Hi Rob,
Thanks for getting in touch! I realize that our documentation around what is and isn't required when importing product feeds can be confusing, especially when different feed consumers around the web have their own requirements. The fields that we care about are mostly the ones we're going to expose directly in the API, so if you've looked at the Product/SKU API you should be familiar with most of them. In particular:
- We use the `item_group_id` column in your feed as the ID of each product and fall back to the `id` column if the former is not specified. The `item_group_id` would be useful to have if you're specifying several variants of the same wine. If each row in your feed corresponds to a different wine, however, you can probably rely on just the `id` column. Google's documentation for this value is quite helpful:
https://support.google.com/merchants/answer/188494?hl=en- The feed columns `title`, `description`, `image_link`, `link` correspond to the `"name"`, `"description", `"images"` array, and `"url"` attributes of a Stripe Product object (
https://stripe.com/docs/api#product_object).
- The field columns `id`, `price`, and `availability` correspond to the `"id"`, `"price"`, and `"inventory"` attributes of a Stripe SKU.
When you import a product feed to Stripe through the Dashboard, you should be able to see how many products and SKUs were imported from that feed. If you run into any issues feel free to get in touch with me and I can look into what might be going wrong when we import the feed.
Using the automated product feed imports might be easier than retrieving each page of products through our API libraries, especially since our node.js bindings currently do not support automatic pagination. By default the API returns 10 results though via the parameter `limit` you can increase that up to 100. You can then call `list()` once, get 100 results, see if you have `has_more: true` and if so you call the API again and pass the last id in the `starting_after` field. There is official documentation of how our pagination works here:
https://stripe.com/docs/api/node#pagination.
Hope that helps, please don't hesitate to reach out if there is anything I can help clarify.
Rasmus