Title: Import productURL
Last modified: November 24, 2020

---

# Import productURL

 *  Resolved [dvk8](https://wordpress.org/support/users/dvk8/)
 * (@dvk8)
 * [5 years, 5 months ago](https://wordpress.org/support/topic/import-producturl/)
 * Hello,
 * When I use the import function under “products” I see a field named “productURL”
   when I select my external URL from the imported csv file nothing seems to happen.
   What does this field do and where should I see it?
 * Thank you in advance

Viewing 4 replies - 1 through 4 (of 4 total)

 *  Plugin Support [EastOfWest a11n](https://wordpress.org/support/users/eastofwest/)
 * (@eastofwest)
 * [5 years, 5 months ago](https://wordpress.org/support/topic/import-producturl/#post-13706058)
 * Hi there!
 * In the [Column Header Reference](https://docs.woocommerce.com/document/product-csv-import-suite-column-header-reference/)
   it says the following about the `product_url` column:
 * > Use if the product is sold on another site. Used by External/Affiliate products
   > only.
 * You can [follow this link to read more](https://docs.woocommerce.com/document/managing-products/#section-16)
   about the External/Affiliate Product type, or sit back and [watch this video primer](https://woocommerce.com/videos/woocommerce-external-affiliate-product-overview/)
   instead.
 *  Thread Starter [dvk8](https://wordpress.org/support/users/dvk8/)
 * (@dvk8)
 * [5 years, 5 months ago](https://wordpress.org/support/topic/import-producturl/#post-13706928)
 * Hi [@eastofwest](https://wordpress.org/support/users/eastofwest/)
 * Thank you for your reply. I think I didn’t explain myself well enough. When I
   import an affiliate product, using the import function, I drag the field “external
   url” from my csv to the “productURL” field. I then fill in the rest of the fields
   and complete the import. The product I just imported seems to appear as a simple
   product, but I want this to be an affiliate product. How can I change this?
 * [Link to site](https://interieurshop24.nl/winkel/)
 * Test 1 is a manually added product with type affiliate. Test 2 is the imported
   product which appears as a simple product
    -  This reply was modified 5 years, 5 months ago by [dvk8](https://wordpress.org/support/users/dvk8/).
 *  Plugin Support [EastOfWest a11n](https://wordpress.org/support/users/eastofwest/)
 * (@eastofwest)
 * [5 years, 5 months ago](https://wordpress.org/support/topic/import-producturl/#post-13707061)
 * I’m a bit lost still – are you using the [built-in CSV import/export mechanism](https://docs.woocommerce.com/document/product-csv-importer-exporter/)
   or a 3rd party plugin?
 * With the built-in product CSV import/export, I’d suggest the best way to start
   is to create one complete product of your own, export that product into a CSV
   file, and use the result as a template for your other products.
 * For instance, below is an image of the result of doing that on a sandbox site.
   Excess columns have been removed, leaving only the minimum required ones. Notice
   the “Type” column – it’s where the type of product is specified, and in this 
   case it has a value “external”.
 * ![](https://d.pr/i/Q85Myl+)
 * Copy the values above into your own spreadsheet, export it as a CSV, and import
   it into your store to see how if it works for you too.
 * If we’re still not on the same page, perhaps include a few screenshots to illustrate.
   You can upload screenshots to your media library and share the link with us, 
   or use a service like [https://droplr.com/](https://droplr.com/) [https://www.getcloudapp.com/](https://www.getcloudapp.com/)
   to share a link to the image file.
 *  Plugin Support [EastOfWest a11n](https://wordpress.org/support/users/eastofwest/)
 * (@eastofwest)
 * [5 years, 5 months ago](https://wordpress.org/support/topic/import-producturl/#post-13738746)
 * It’s been a while since the last reply to this thread, so I’m going to go ahead
   and close it. If you require help with anything else, please feel free to start
   a new one.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Import productURL’ is closed to new replies.

 * ![](https://ps.w.org/woocommerce/assets/icon.svg?rev=3234504)
 * [WooCommerce](https://wordpress.org/plugins/woocommerce/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woocommerce/)
 * [Active Topics](https://wordpress.org/support/plugin/woocommerce/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woocommerce/reviews/)

## Tags

 * [column](https://wordpress.org/support/topic-tag/column/)
 * [csv](https://wordpress.org/support/topic-tag/csv/)
 * [external](https://wordpress.org/support/topic-tag/external/)

 * 4 replies
 * 2 participants
 * Last reply from: [EastOfWest a11n](https://wordpress.org/support/users/eastofwest/)
 * Last activity: [5 years, 5 months ago](https://wordpress.org/support/topic/import-producturl/#post-13738746)
 * Status: resolved