Title: Sample Product Upload CSV / XML / Spreadsheet Last modified: October 31, 2019 --- # Sample Product Upload CSV / XML / Spreadsheet * Resolved [woowoo101](https://wordpress.org/support/users/woowoo101/) * (@woowoo101) * [6 years, 6 months ago](https://wordpress.org/support/topic/sample-product-upload-csv-xml-spreadsheet/) * Somebody please check out the GitHub downloads for sample bulk product upload spreasdheet at [https://github.com/woocommerce/woocommerce/tree/master/sample-data](https://github.com/woocommerce/woocommerce/tree/master/sample-data) * Most importantly: no way to open CSV in any meaningful way in LibreOffice Calc No way to import XML into LibreOffice Calc * This is likely to make people swipe left and try a different cart. Why you do this? * My solution: * Go here: [https://docs.woocommerce.com/document/product-csv-importer-exporter/](https://docs.woocommerce.com/document/product-csv-importer-exporter/) * Then click through to here: [https://github.com/woocommerce/woocommerce/wiki/Product-CSV-Import-Schema#csv-columns-and-formatting](https://github.com/woocommerce/woocommerce/wiki/Product-CSV-Import-Schema#csv-columns-and-formatting) * Then make your own CSV based on that (not done it yet). * ______________________________________________________ Predicted response (please, don’t bother replying if it’s the following): – You use LibreOffice? Use Lotus 1-2-3 silly! – Update your LibreOffice! – You are rude therefore l will not answer you but l do actually know the answer ______________________________________________________ * Still, 2 questions remain: * – HOW DO I MAKE WOOCOMMERCE SHOW RECENTLY UPLOADED PRODUCTS? (l see the column for featured products. But l also want RECENT products. Not even sure if any template supports that, but it’s needed. You know, for marketing? To sell the things to the people?) * – IS THE SKU FIELD GOING TO BE VISIBLE TO PUBLIC? Disappoint me now. Y’all gone and made it visible to the public for no good reason haven’t you? So now l can’t write private notes in the SKU i.e. date of original product creation so that l can see when to start discounting. * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fsample-product-upload-csv-xml-spreadsheet%2F%3Foutput_format%3Dmd&locale=en_US) to see the link]_ Viewing 5 replies - 1 through 5 (of 5 total) * [seank123](https://wordpress.org/support/users/seank123/) * (@seank123) * [6 years, 6 months ago](https://wordpress.org/support/topic/sample-product-upload-csv-xml-spreadsheet/#post-12086765) * The CSV opens in Calc perfectly ok for me… * For product sorting do you mean in the front end – ie: display latest products first? If so, then it’s in the Appearance – Customise – WooCommerce – Product Catalogue – Default Product Sorting * The SKU is a product code – why are you writing notes in it?? * Thread Starter [woowoo101](https://wordpress.org/support/users/woowoo101/) * (@woowoo101) * [6 years, 6 months ago](https://wordpress.org/support/topic/sample-product-upload-csv-xml-spreadsheet/#post-12086990) * Hi there, * For me the CSV doesn’t open, may l ask what your Calc settings are for opening the CSV, you know, when it gives you a dialogue with checkboxes? * Maybe l have some overhang with settings from a previous CSV l messed around with. * As for SKU, there is the option to make it private with at least one other shopping cart. Also, my question again: is it going to be visible? * Reason: whatever reason 🙂 in fact l explained in OP. Don’t worry, l know what l am doing. * Where else am l gonna write this info that l put in SKU? * [seank123](https://wordpress.org/support/users/seank123/) * (@seank123) * [6 years, 6 months ago](https://wordpress.org/support/topic/sample-product-upload-csv-xml-spreadsheet/#post-12087027) * Calc settings are: * [https://drive.google.com/open?id=1N36a4tdGwv0g_OdPPdHtAlMXqQhx0RaC](https://drive.google.com/open?id=1N36a4tdGwv0g_OdPPdHtAlMXqQhx0RaC) * You can hide the SKU with a code snippet: * [https://businessbloomer.com/woocommerce-hide-sku-front-end/](https://businessbloomer.com/woocommerce-hide-sku-front-end/) * Thread Starter [woowoo101](https://wordpress.org/support/users/woowoo101/) * (@woowoo101) * [6 years, 6 months ago](https://wordpress.org/support/topic/sample-product-upload-csv-xml-spreadsheet/#post-12088236) * Thank you squire! Much obliged :))) If l don’t reply within a week it means it worked perfectly! * Plugin Support [Fernando a11n](https://wordpress.org/support/users/fhaps/) * (@fhaps) * Automattic Happiness Engineer * [6 years, 6 months ago](https://wordpress.org/support/topic/sample-product-upload-csv-xml-spreadsheet/#post-12116141) * We haven’t heard back from you in a while, so as per your message above, I’m going to mark this as resolved – if you have any further questions, you can start a new thread. Viewing 5 replies - 1 through 5 (of 5 total) The topic ‘Sample Product Upload CSV / XML / Spreadsheet’ 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 * [bulk upload](https://wordpress.org/support/topic-tag/bulk-upload/) * [csv](https://wordpress.org/support/topic-tag/csv/) * [latest products](https://wordpress.org/support/topic-tag/latest-products/) * [sku](https://wordpress.org/support/topic-tag/sku/) * [xml](https://wordpress.org/support/topic-tag/xml/) * 5 replies * 3 participants * Last reply from: [Fernando a11n](https://wordpress.org/support/users/fhaps/) * Last activity: [6 years, 6 months ago](https://wordpress.org/support/topic/sample-product-upload-csv-xml-spreadsheet/#post-12116141) * Status: resolved