This article goes over the one-time product export including what is included in the report as well as frequently asked questions.
How to export one-time products
Go to the Products page on the Merchant portal, and click One-Time Products.
From there, you’ll find the Export button on the right side of the page. Click this button, and then choose one of the following options:
- Export CSV - All One-Time Products. This file will include all one-time products, visible or hidden.
- Export CSV - Current Filter. If you’ve selected “Visible” or “Hidden” products as part of the one-time product filter, this file will include all one-time products that fit that filter.
You will then see a download status bar pop up at the top of your screen. Once the status bar tells you the export is ready, you can click Download now.
Information in the one-time product export
The one-time product export includes the following information:
| Field | Description |
| SKU | SKU for each Product and Variant combination. |
| Product ID | Cratejoy Product ID for each product. Note: Product variants share the same product ID, so there may be multiple lines with the same product ID if there are product variants. |
| Product Name | Name for one-time product. |
| Product Variant | If using variants, there will b a comma-separated list of the potential product variants. If not using variants, field will be empty. |
| Visibility | Whether the product is visible or hidden on the Storefront. |
| MP Visibility | Whether the product is visible or hidden on the Marketplace. Note: One-time products are always hidden on the Marketplace, so this will always be Hidden. |
| Price | Price of one-time product. Note: $17.95 will show up as 1795 in your export. |
| Product Image | Product image URL for the oldest image uploaded for the associated product ID. |
| Description | One-time product description. |
| Inventory | If inventory tracking enabled, this number will be the quantity on hand. Note: This is not including any confidence intervals. |
Frequently Asked Questions
Does this export include deleted products?
No. This export only includes one-time products that are visible or hidden.
How can I get a one-time product URL for affiliate links or ads?
Your one-time product’s URL will vary, depending on how you set up your site. In many cases it may use the “Product ID” field to construct the URL.
How can I get my subscription products in the same export?
Go to the subscription products page and export your products there. The columns for both reports should match, up to and including the Description column, so it will be easy to combine those reports.
Why is there a column that says “MP Visibility” in my One-Time Products Export?
You cannot sell one-time products on the Cratejoy Marketplace. However, we wanted to standardize the product export columns across One-Time Products and Subscription Products. This means that the MP Visibility column on your One-Time Product export will always say “Hidden,” but the columns will match up with your Subscription Product export.
Who can export these reports?
Users who have the role Admin or Product Manager can export these one-time product exports. On the "Users" page, they have "Export Ecommerce Products" as an available action.
Can I see my SKU in this export?
You can use the One-Time Product export to view your SKUs for these products.