{"id":69916,"date":"2019-07-05T23:26:33","date_gmt":"2019-07-05T21:26:33","guid":{"rendered":"https:\/\/www.sellermania.com\/an-alternative-to-excel-to-transform-your-files\/"},"modified":"2021-05-19T18:31:46","modified_gmt":"2021-05-19T16:31:46","slug":"an-alternative-to-excel-to-transform-your-files","status":"publish","type":"post","link":"https:\/\/www.sellermania.com\/en\/blog\/news-en\/an-alternative-to-excel-to-transform-your-files\/","title":{"rendered":"An alternative to Excel to transform your files"},"content":{"rendered":"\n

Tired of repeating the same actions in Excel? To transform your supplier files into usable files? To transform yourself into an Excel expert to sell on marketplaces?<\/p>\n\n

If you are a geek at heart, you know how to make macros in Excel<\/a> , you click a button and transform your file format, rename columns, concatenate different cells, find-replace, and in the blink of an eye your original file is transformed into a usable format.<\/p>\n\n

If you’re not a geek at heart, like most\nof us, you spend a lot of time doing all these operations\nmanually, which wastes you a lot of time. <\/p>\n\n

The benefit: time saving which avoids having to go through Excel each time<\/strong><\/h2>\n\n

See the Mapper as if you had programmed a\ngigantic Excel macro that transforms your file from one format to another,\nand this without knowing neither Excel, nor the macro, and even less the VBA code.<\/p>\n\n

The Sellermania Mapper is a rule editor, extremely flexible and easy to use<\/strong> <\/h2>\n\n

It allows you to transform a product catalog from one format to another, automatically and as many times as you want. In computer science this is called an ETL (Extract Transform Load). The Mapper is an ETL accessible to all, which targets e-merchants, product managers, buyers or even project managers. It is able to replace the manipulations you do manually in Excel, without the need to learn to code in VBA.<\/p>\n\n

How does it work ? <\/strong><\/h2>\n\n

As input, we load a file or a flux<\/a> , which can be a CSV file for example, containing all the product (or other) data. And on output, the file comes out transformed, cleaned, according to the desired format. <\/p>\n\n

In the midst of these two operations, a number of\nrules apply, over which you have complete control <\/p>\n\n

The Mapper: a tool currently used mainly to create new products on marketplaces.<\/strong> <\/h2>\n\n

E-merchants inject a product flow, which comes from\ntheir information system, website, logistics, suppliers, and in\noutput, they retrieve a file in Amazon, Cdiscount, Fnac, Mano Mano format\netc. Completely automated, they can thus create products on\nmarketplaces automatically, without needing to change the way they\nwork upstream. <\/p>\n\n

It has many other applications: transforming the\nsupplier’s file in exploitable format for your e-commerce site,\nmodify your product file so that it conforms to what you require\na distributor, standardize several files that have different formats\nin order to obtain a unique format. It can even accept files as input\nother than products: internally, we also use it to transform\nour customer invoice files in Debit \/ Credit format for the\naccounting!<\/p>\n","protected":false},"excerpt":{"rendered":"

Tired of repeating the same actions in Excel? To transform your supplier files into usable files? To transform yourself into an Excel expert to sell on marketplaces? If you are a geek at heart, you know how to make macros in Excel , you click a button and transform your file format, rename columns, concatenate […]<\/p>\n","protected":false},"author":6,"featured_media":61440,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"content-type":"","footnotes":""},"categories":[1392],"tags":[],"class_list":["post-69916","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-news-en","entry","has-media"],"_links":{"self":[{"href":"https:\/\/www.sellermania.com\/en\/wp-json\/wp\/v2\/posts\/69916","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sellermania.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sellermania.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sellermania.com\/en\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sellermania.com\/en\/wp-json\/wp\/v2\/comments?post=69916"}],"version-history":[{"count":0,"href":"https:\/\/www.sellermania.com\/en\/wp-json\/wp\/v2\/posts\/69916\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sellermania.com\/en\/wp-json\/wp\/v2\/media\/61440"}],"wp:attachment":[{"href":"https:\/\/www.sellermania.com\/en\/wp-json\/wp\/v2\/media?parent=69916"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sellermania.com\/en\/wp-json\/wp\/v2\/categories?post=69916"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sellermania.com\/en\/wp-json\/wp\/v2\/tags?post=69916"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}