{"id":259,"date":"2024-01-19T13:58:59","date_gmt":"2024-01-19T13:58:59","guid":{"rendered":"https:\/\/www.shipnerd.net\/support\/?page_id=259"},"modified":"2024-02-22T19:16:07","modified_gmt":"2024-02-23T00:16:07","slug":"csv-file-import","status":"publish","type":"page","link":"https:\/\/www.shipnerd.net\/support\/marketplaces\/csv-file-import\/","title":{"rendered":"CSV File Import"},"content":{"rendered":"\n<div class=\"wp-block-group has-base-2-background-color has-background has-global-padding is-layout-constrained wp-container-core-group-is-layout-2addec81 wp-block-group-is-layout-constrained\" style=\"padding-top:var(--wp--preset--spacing--20);padding-right:var(--wp--preset--spacing--20);padding-bottom:var(--wp--preset--spacing--20);padding-left:var(--wp--preset--spacing--20)\">\n<p class=\"crumbs\"><a href=\"\/support\/\">Support Home<\/a> &gt; <a href=\"\/support\/marketplaces\/\">Marketplace Integrations<\/a> &gt;<br><\/p>\n\n\n\n<h1 class=\"wp-block-heading\">CSV File Import<\/h1>\n\n\n\n<figure class=\"wp-block-embed is-type-rich is-provider-embed-handler wp-block-embed-embed-handler wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"ShipNerd  How to import a CSV file into ShipNerd\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/tV8UKmWRU0s?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<p>ShipNerd&#8217;s CSV import tool is a great way to import shipping data and create shipping labels in batches.&nbsp;Download an example of a CSV file&nbsp;<a href=\"https:\/\/www.shipnerd.net\/support\/wp-content\/uploads\/2024\/02\/csv_example_spreadsheet-2.xlsx\" target=\"_blank\" rel=\"noreferrer noopener\">here<\/a>&nbsp;to see the default header structure (or view below). This is the format your CSV file must be in when you import it into our system.&nbsp;<\/p>\n\n\n\n<p>If you would like to modify the data structure of the file to match your current structure, please contact us for further assistance:&nbsp;<a href=\"mailto:support@shipnerd.com\">support@shipnerd.com<\/a>&nbsp;&nbsp;<\/p>\n\n\n\n<p>You can also&nbsp;export&nbsp;a CSV file from ShipNerd to extract a report that has filtered orders with matching tracking numbers in case you need to upload the tracking information to another platform.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-contrast-color has-alpha-channel-opacity has-contrast-background-color has-background is-style-wide\" style=\"margin-top:var(--wp--preset--spacing--30);margin-bottom:var(--wp--preset--spacing--30)\"\/>\n\n\n\n<p><strong>INSTRUCTIONS<\/strong>:<\/p>\n\n\n\n<p>1) Import your CSV file using the &#8220;Import CSV&#8221; feature on the My Shipments page.&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"738\" height=\"277\" src=\"https:\/\/www.shipnerd.net\/support\/wp-content\/uploads\/2024\/02\/f63db128-31b5-4194-82d7-b75411371cd6.png\" alt=\"\" class=\"wp-image-1588\" srcset=\"https:\/\/www.shipnerd.net\/support\/wp-content\/uploads\/2024\/02\/f63db128-31b5-4194-82d7-b75411371cd6.png 738w, https:\/\/www.shipnerd.net\/support\/wp-content\/uploads\/2024\/02\/f63db128-31b5-4194-82d7-b75411371cd6-300x113.png 300w\" sizes=\"auto, (max-width: 738px) 100vw, 738px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-contrast-color has-alpha-channel-opacity has-contrast-background-color has-background is-style-wide\" style=\"margin-top:var(--wp--preset--spacing--30);margin-bottom:var(--wp--preset--spacing--30)\"\/>\n\n\n\n<p>2) Once imported, you&#8217;ll be able to view the data in a structured format for review.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-contrast-color has-alpha-channel-opacity has-contrast-background-color has-background is-style-wide\" style=\"margin-top:var(--wp--preset--spacing--30);margin-bottom:var(--wp--preset--spacing--30)\"\/>\n\n\n\n<p>3) Click &#8220;Create Labels&#8221; and select a shipping speed to batch generate labels for the entire CSV file.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-contrast-color has-alpha-channel-opacity has-contrast-background-color has-background is-style-wide\" style=\"margin-top:var(--wp--preset--spacing--30);margin-bottom:var(--wp--preset--spacing--30)\"\/>\n\n\n\n<p>4) Once your labels are ready, we will notify you by email, &nbsp;and by a real-time notification in case you&#8217;re still working on ShipNerd (this could take a minute or so depending on how many labels). &nbsp;You&#8217;ll receive a link in the notification to download a single PDF file containing all of your labels, as well as information about any failed labels.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-contrast-color has-alpha-channel-opacity has-contrast-background-color has-background is-style-wide\" style=\"margin-top:var(--wp--preset--spacing--30);margin-bottom:var(--wp--preset--spacing--30)\"\/>\n\n\n\n<p>5) All of the shipments in the file will be visible on the My Shipments page with the respective tracking number, and courier information.<\/p>\n\n\n\n<p>Your spreadsheet structure should be formatted like the example below. All fields are required unless otherwise noted.&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/www.shipnerd.net\/support\/wp-content\/uploads\/2024\/03\/csv_example_spreadsheet.xlsx\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" src=\"https:\/\/cdn.filestackcontent.com\/hPuVIgzmTGuUEd8rwNVA\" alt=\"\"\/><\/a><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-contrast-color has-alpha-channel-opacity has-contrast-background-color has-background is-style-wide\" style=\"margin-top:var(--wp--preset--spacing--30);margin-bottom:var(--wp--preset--spacing--30)\"\/>\n\n\n\n<p><strong>Ready to import CSV?<\/strong><\/p>\n\n\n\n<p>Please email us at&nbsp;<a href=\"mailto:support@shipnerd.com\">support@shipnerd.com<\/a>&nbsp;once you&#8217;re ready to start importing and we&#8217;ll contact you to ensure your account is configured to start shipping.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Support Home &gt; Marketplace Integrations &gt; CSV File Import ShipNerd&#8217;s CSV import tool is a great way to import shipping data and create shipping labels in batches.&nbsp;Download an example of a CSV file&nbsp;here&nbsp;to see the default header structure (or view below). This is the format your CSV file must be in when you import it [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":247,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"page-no-title","meta":{"footnotes":""},"class_list":["post-259","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.shipnerd.net\/support\/wp-json\/wp\/v2\/pages\/259","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.shipnerd.net\/support\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.shipnerd.net\/support\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.shipnerd.net\/support\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.shipnerd.net\/support\/wp-json\/wp\/v2\/comments?post=259"}],"version-history":[{"count":3,"href":"https:\/\/www.shipnerd.net\/support\/wp-json\/wp\/v2\/pages\/259\/revisions"}],"predecessor-version":[{"id":1590,"href":"https:\/\/www.shipnerd.net\/support\/wp-json\/wp\/v2\/pages\/259\/revisions\/1590"}],"up":[{"embeddable":true,"href":"https:\/\/www.shipnerd.net\/support\/wp-json\/wp\/v2\/pages\/247"}],"wp:attachment":[{"href":"https:\/\/www.shipnerd.net\/support\/wp-json\/wp\/v2\/media?parent=259"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}