Finalize Excel File
You need to fill in 6 columns in an Excel file (name UA, name RU, description UA, description RU, keywords UA, keywords RU). You can use ChatGPT. Below is the prompt for this task that was used to fill in the first 17 files (but it’s better to check to ensure the result meets the requirements). IMPORTANT! Do not change the order of the rows. Fill everything in the same format as it is now.
Task: for the list of products (I will send in batches) prepare content for marketplaces in 2 languages: UA + RU.
I will send a list of product names (usually 5 items, sometimes more). The names may include brand, series/model, sizes, power, voltage, capacity, quantity per package, color, etc.
Critical requirements:
1) In the NAMES, do not remove important product characteristics: brand, model/series, size/dimensions, power, voltage, capacity, type of power supply, quantity in the package, material, color, etc. Do not lose anything important.
2) The names must be UNIQUE for marketplaces: readable, logical, without garbage, but preserving key characteristics.
3) Descriptions: detailed, complete, 2–4 paragraphs (or 6–10 sentences). In the description, it is MANDATORY to repeat the characteristics (what is in the name) and add purpose/application, where the advantages and recommendations for use/selection are used. Do not invent anything that is not in the input name (if unsure - formulate neutrally).
4) Keywords: for UA and RU – no more than 1024 characters for each language. The keys should be as generalized as possible (without sizes, capacities, colors, voltages, power, without "18650", "3/4", "VPR-18", etc.). Their purpose is to cover the maximum search audience. Use broad queries/categories/synonyms/purposes. Keys - separated by commas.
5) If the products are similar (one series/type that differ only in characteristics), it is allowed to make the same keywords and almost the same descriptions, BUT in the descriptions and names the characteristics must differ correctly.
Output structure (strictly, without tables, for easy copying into Excel):
Block 1: all Names UA in a row — 1 line per product (in the same order as in the input)
Block 2: all Names RU in a row - 1 line per product
Block 3: all Keywords UA in a row — 1 line per product
Block 4: all Keywords RU in a row - 1 line per product
Block 5: all Descriptions UA in a row — 1 line per product (without line breaks within the description; if long — the same in one line)
Block 6: all Descriptions RU in a row - 1 line per product (also in one line)
Additionally:
- maintain the order of products.
- Do not add numbering, bullets, headers “UA/RU/Keywords/Description” – only lines of content.
- Units of measurement and symbols: V/W/lm/mAh/mm/cm/kW – as in the original, bring to a neat appearance.
- If the input is in UA – still make both UA and RU versions.
Start working immediately after receiving the list of products.
Applications 1
-
693 15 0 2 Good day! I have familiarized myself with the technical specifications! The task is clear, I will complete it today, shall we work?