Sort and set a table of goods
1 .Set/sets/gels for shower/desodorants and everything that does not relate to perfume remove
2ndRemove all subsidiary goods that are in volume less than 20 ml (these include testers/probbers/otlivants and simply volume)
ThreeEach parent goods has the first five compulsory subsidiary goods:
3 ml of delivant
5 ml of delivant
10 ml of delivant
15 ml of delivant
20 ml of delivant
4 .The name of the subsidiary goods must contain only the volume ("50 ml" or "3 ml of distillant")
and 5.The column "Attribute 1 value(s)" for subsidiary goods copies the value of the column "Name"
6 .Column "Attribute 1 value(s)" for parental goods - list the value of all subsidiary goods through the
7 .SKU prescribe simultaneously for each subsidiary goods
Example: “SKU of the parent” – “his order number”
779 - 0
779-1
779 – 2
779 to 3
8 .Subsidiary goods must be sorted to return volume
The 9.The volume should not be repeated.There should not be two child goods in one parent with the same volumes.
The table to be converted:
List 1 - The table to be converted
List 2 - Example of the result for the first 3 goods (Double fields hidden, there are no changes in them, they are the same for all subsidiary goods)
Applications 1
-
1 day14 USD
104 1 day14 USD
Hello to you. I am a newbie to work on the freelance exchange, but experience working with large databases I have significant. The work is understandable. Please trust the execution. I will perform in time.
-
5 days33 USD
345 22 0 5 days33 USD
Hello to you. Ready to perform the task. I will be happy to cooperate. turn to
-
2 days22 USD
647 11 1 2 days22 USD
Good Morning Arthur.
I specialize in Excel/Google tables and automation in this.
Ready to complete the order, start the work immediately.
I will be happy to work with you, good day.
-
1 day17 USD
313 58 0 1 day17 USD
Thanks to the experience with parsing and packing goods, there are their own tools for the most efficient packing of variable goods. I will be happy to perform
-
2 days18 USD
192 2 days18 USD
Good morning, I am interested in your order, I have great experience working with Excel, I will do it quality.
-
1 day22 USD
620 8 1 1 day22 USD
Good day !
If the product table's "setting" is done periodically, I suggest to make a script that automates the task. The script will be in the PHP language, I have great experience working with it (2+ years).
If you are interested, please write to me in person.
-
1 day22 USD
570 7 1 1 day22 USD
Welcome to! I do the task quickly and efficiently. I have a great experience working with Exel.
-
1 day33 USD
3668 107 0 1 day33 USD
Do you have such a task often? Or just once?
Can it be easier not to do it by hand, but to write a script that will automatically realize it?
They pressed the button and it was done.
You can use it for each new table.
-
1. Комплекты/наборы/гели для душа/дезедоранты и все что не касается парфюмерии убираем
Есть ли какие-то формальные критерии насчет "касается/не касается" или надо в каждый всматриваться и принимать решение?
-
Current freelance projects in the category Databases & SQL
Database parsing
45 USD
Channel requirements: 1. Content language: Russian or Ukrainian (mixed RU/UA content is allowed) 2. Number of subscribers: At least 500 subscribers 3. Activity: The last post published no later than 32 hours ago 4. Comments: Comments must be open under the posts (through a group… Databases & SQL, Data Parsing ∙ 11 hours 13 minutes back ∙ 27 proposals |
It is necessary to check the scripts and update the data in the Postgres database.It is necessary to correct the SQL scripts for the Postgres database. It is required to check the scripts and update data from external Excel tables and between two Postgres databases (different servers). Scripts will be run through AnyDesk using Navicat. List of data for… Databases & SQL ∙ 3 days 14 hours back ∙ 18 proposals |
Need an Airtable architect to build a relational schema and a new clean Airtable base.Need help rethinking and building a clean relational schema for an internal operational system on Airtable. The current database is already in use by the team, but it has grown organically: the structure is partially flat, some tables/views are actively used, while others are… Databases & SQL, Desktop Apps ∙ 4 days 7 hours back ∙ 10 proposals |
Basketball Coaching Education Platform + Custom CMSBasketball Coaching Education Platform + Custom CMSProject Overview We are looking for an experienced web development team or full-stack developer to build a modern basketball coaching education platform. The website will provide basketball coaches with access to educational… Databases & SQL, Web Programming ∙ 5 days 1 hour back ∙ 92 proposals |
Integration of Viber in 8.3
223 USD
Need Viber integration into own CRM (1C 8.3)About the Company The company "Domofon System" is engaged in the installation and maintenance of intercom systems. Base of over 40,000 subscribers. We work on our own customized system based on 1C 8.3. We are looking for a specialist… Databases & SQL, Bot Development ∙ 5 days 4 hours back ∙ 18 proposals |
Kharkiv