{"id":2355,"date":"2012-02-08T17:40:09","date_gmt":"2012-02-08T17:40:09","guid":{"rendered":"https:\/\/www.inmotionhosting.com\/support\/2012\/02\/08\/322-using-the-bulk-export-import-extension-in-opencart\/"},"modified":"2023-12-22T15:25:47","modified_gmt":"2023-12-22T20:25:47","slug":"opencart-bulk-export-import-extension","status":"publish","type":"post","link":"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/opencart-bulk-export-import-extension\/","title":{"rendered":"Using the Bulk Export\/ Import Extension in OpenCart"},"content":{"rendered":"

Now that you have installed the bulk import\/ export tool for OpenCart<\/a>, you can begin using it to add or modify products in your OpenCart store. The first step is to export your existing products so you know how the spreadsheets work. Then you can add products to the spreadsheet offline and upload the file once you have finished.\u00a0<\/p>\n

    \n
  1. Log into the OpenCart Dashboard<\/a><\/li>\n
  2. Go to System > Export\/ Import<\/strong><\/li>\n

    \"opencart_import_1\"<\/a><\/p>\n

    <\/div>\n\n
  3. Click \u201cExport<\/strong>\u201d to download an Excel spreadsheet of your current products<\/li>\n

    \"opencart_import_2\"<\/a><\/p>\n

    <\/div>\n\n
  4. Open the spreadsheet with the appropriate software such as Open Office or Microsoft Excel<\/li>\n

    \"opencart_import_3\"<\/a><\/p>\n

    <\/div>\n\n

    Notice at the bottom of the spreadsheet, there is 7 separate sheets<\/strong> to work with (categories, products, options, attributes, specials, discounts, and rewards<\/em>)<\/p>\n

  5. Once you are done adding the products you want to add, in the correct format as your current products are laid out on the spreadsheet, save the file<\/strong><\/li>\n
  6. Now, go back to your OpenCart dashboard to: System Export\/ Import<\/strong><\/li>\n
  7. Choose the file you just saved on your local computer by clicking the \u201cChoose File<\/strong>\u201d button next to \u201cImport from spreadsheet file:<\/strong>\u201d<\/li>\n
  8. Once you save selected a file, click \u201cImport<\/strong>\u201d<\/li>\n

    \"opencart_import_4\"<\/a><\/p>\n

    <\/div>\n\n<\/ol>\n

    Once you have successfully imports your categories and products you will get a message on the top of your screen letting you know it has completed.<\/p>\n

    \"opencart_import_5\"<\/a><\/p>\n

    <\/div>\n

    If you need further assistance please feel free to ask a question on our support center<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"

    Now that you have installed the bulk import\/ export tool for OpenCart, you can begin using it to add or modify products in your OpenCart store. The first step is to export your existing products so you know how the spreadsheets work. Then you can add products to the spreadsheet offline and upload the file Read More ><\/a><\/p>\n","protected":false},"author":56983,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[81],"tags":[],"class_list":["post-2355","post","type-post","status-publish","format-standard","hentry","category-opencart"],"acf":[],"yoast_head":"\nUsing the Bulk Export\/ Import Extension in OpenCart | InMotion Hosting<\/title>\n<meta name=\"description\" content=\"Learn how to use the Export\/ Import extension in OpenCart to add bulk products to your shopping cart.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/opencart-bulk-export-import-extension\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Using the Bulk Export\/ Import Extension in OpenCart | InMotion Hosting\" \/>\n<meta property=\"og:description\" content=\"Learn how to use the Export\/ Import extension in OpenCart to add bulk products to your shopping cart.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/opencart-bulk-export-import-extension\/\" \/>\n<meta property=\"og:site_name\" content=\"InMotion Hosting Support Center\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/inmotionhosting\/\" \/>\n<meta property=\"article:published_time\" content=\"2012-02-08T17:40:09+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-22T20:25:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/02\/opencart_opencart_import_1.jpg\" \/>\n<meta name=\"author\" content=\"Carrie Smaha\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@carriesmaha\" \/>\n<meta name=\"twitter:site\" content=\"@InMotionHosting\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Carrie Smaha\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/opencart-bulk-export-import-extension\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/opencart-bulk-export-import-extension\/\"},\"author\":{\"name\":\"Carrie Smaha\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/595948dab2995d347a87076abdae19d8\"},\"headline\":\"Using the Bulk Export\/ Import Extension in OpenCart\",\"datePublished\":\"2012-02-08T17:40:09+00:00\",\"dateModified\":\"2023-12-22T20:25:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/opencart-bulk-export-import-extension\/\"},\"wordCount\":236,\"commentCount\":131,\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/opencart-bulk-export-import-extension\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/02\/opencart_opencart_import_1.jpg\",\"articleSection\":[\"OpenCart\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/opencart-bulk-export-import-extension\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/opencart-bulk-export-import-extension\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/opencart-bulk-export-import-extension\/\",\"name\":\"Using the Bulk Export\/ Import Extension in OpenCart | InMotion Hosting\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/opencart-bulk-export-import-extension\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/opencart-bulk-export-import-extension\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/02\/opencart_opencart_import_1.jpg\",\"datePublished\":\"2012-02-08T17:40:09+00:00\",\"dateModified\":\"2023-12-22T20:25:47+00:00\",\"description\":\"Learn how to use the Export\/ Import extension in OpenCart to add bulk products to your shopping cart.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/opencart-bulk-export-import-extension\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/opencart-bulk-export-import-extension\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/opencart-bulk-export-import-extension\/#primaryimage\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/02\/opencart_opencart_import_1.jpg\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/02\/opencart_opencart_import_1.jpg\",\"width\":1577,\"height\":678,\"caption\":\"opencart_import_1\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/opencart-bulk-export-import-extension\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.inmotionhosting.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Using the Bulk Export\/ Import Extension in OpenCart\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/\",\"name\":\"InMotion Hosting Support Center\",\"description\":\"Web Hosting Support & Tutorials\",\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.inmotionhosting.com\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\",\"name\":\"InMotion Hosting\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg\",\"width\":696,\"height\":696,\"caption\":\"InMotion Hosting\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/inmotionhosting\/\",\"https:\/\/x.com\/InMotionHosting\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/595948dab2995d347a87076abdae19d8\",\"name\":\"Carrie Smaha\",\"description\":\"Carrie Smaha is a Senior Marketing Operations leader with over 20 years of experience in digital strategy, web development, and IT project management. She specializes in go-to-market programs and SaaS solutions for WordPress and VPS Hosting, working closely with technical teams and customers to deliver high-performance, scalable platforms. At InMotion Hosting, she drives product marketing initiatives that blend strategic insight with technical depth.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/carriesmaha\/\",\"https:\/\/x.com\/carriesmaha\"],\"url\":\"https:\/\/www.inmotionhosting.com\/support\/author\/carries\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Using the Bulk Export\/ Import Extension in OpenCart | InMotion Hosting","description":"Learn how to use the Export\/ Import extension in OpenCart to add bulk products to your shopping cart.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/opencart-bulk-export-import-extension\/","og_locale":"en_US","og_type":"article","og_title":"Using the Bulk Export\/ Import Extension in OpenCart | InMotion Hosting","og_description":"Learn how to use the Export\/ Import extension in OpenCart to add bulk products to your shopping cart.","og_url":"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/opencart-bulk-export-import-extension\/","og_site_name":"InMotion Hosting Support Center","article_publisher":"https:\/\/www.facebook.com\/inmotionhosting\/","article_published_time":"2012-02-08T17:40:09+00:00","article_modified_time":"2023-12-22T20:25:47+00:00","og_image":[{"url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/02\/opencart_opencart_import_1.jpg","type":"","width":"","height":""}],"author":"Carrie Smaha","twitter_card":"summary_large_image","twitter_creator":"@carriesmaha","twitter_site":"@InMotionHosting","twitter_misc":{"Written by":"Carrie Smaha","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/opencart-bulk-export-import-extension\/#article","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/opencart-bulk-export-import-extension\/"},"author":{"name":"Carrie Smaha","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/595948dab2995d347a87076abdae19d8"},"headline":"Using the Bulk Export\/ Import Extension in OpenCart","datePublished":"2012-02-08T17:40:09+00:00","dateModified":"2023-12-22T20:25:47+00:00","mainEntityOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/opencart-bulk-export-import-extension\/"},"wordCount":236,"commentCount":131,"publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/opencart-bulk-export-import-extension\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/02\/opencart_opencart_import_1.jpg","articleSection":["OpenCart"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/opencart-bulk-export-import-extension\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/opencart-bulk-export-import-extension\/","url":"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/opencart-bulk-export-import-extension\/","name":"Using the Bulk Export\/ Import Extension in OpenCart | InMotion Hosting","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/opencart-bulk-export-import-extension\/#primaryimage"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/opencart-bulk-export-import-extension\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/02\/opencart_opencart_import_1.jpg","datePublished":"2012-02-08T17:40:09+00:00","dateModified":"2023-12-22T20:25:47+00:00","description":"Learn how to use the Export\/ Import extension in OpenCart to add bulk products to your shopping cart.","breadcrumb":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/opencart-bulk-export-import-extension\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/opencart-bulk-export-import-extension\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/opencart-bulk-export-import-extension\/#primaryimage","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/02\/opencart_opencart_import_1.jpg","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/02\/opencart_opencart_import_1.jpg","width":1577,"height":678,"caption":"opencart_import_1"},{"@type":"BreadcrumbList","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/opencart-bulk-export-import-extension\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.inmotionhosting.com\/support\/"},{"@type":"ListItem","position":2,"name":"Using the Bulk Export\/ Import Extension in OpenCart"}]},{"@type":"WebSite","@id":"https:\/\/www.inmotionhosting.com\/support\/#website","url":"https:\/\/www.inmotionhosting.com\/support\/","name":"InMotion Hosting Support Center","description":"Web Hosting Support & Tutorials","publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.inmotionhosting.com\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.inmotionhosting.com\/support\/#organization","name":"InMotion Hosting","url":"https:\/\/www.inmotionhosting.com\/support\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","width":696,"height":696,"caption":"InMotion Hosting"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/inmotionhosting\/","https:\/\/x.com\/InMotionHosting"]},{"@type":"Person","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/595948dab2995d347a87076abdae19d8","name":"Carrie Smaha","description":"Carrie Smaha is a Senior Marketing Operations leader with over 20 years of experience in digital strategy, web development, and IT project management. She specializes in go-to-market programs and SaaS solutions for WordPress and VPS Hosting, working closely with technical teams and customers to deliver high-performance, scalable platforms. At InMotion Hosting, she drives product marketing initiatives that blend strategic insight with technical depth.","sameAs":["https:\/\/www.linkedin.com\/in\/carriesmaha\/","https:\/\/x.com\/carriesmaha"],"url":"https:\/\/www.inmotionhosting.com\/support\/author\/carries\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"primary_category":null,"_links":{"self":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/2355","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/users\/56983"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/comments?post=2355"}],"version-history":[{"count":3,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/2355\/revisions"}],"predecessor-version":[{"id":108571,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/2355\/revisions\/108571"}],"wp:attachment":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/media?parent=2355"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/categories?post=2355"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/tags?post=2355"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}