Project translated automatically. Log in or register, to view the original (The executive has been chosen) What is the name of the process?How should it appear in the selector?Is it necessary to validate the entering file (check headlines, field filling, etc.)The ?- No how the application should behave when an error occurs (the user has accidentally specified not the entering file, the file is opened by another application and cannot be read, the file is damaged... ) ?The conclusion of the error Where to keep the result?On the work table • • • • • • • • • The Title and Description columns must be checked on (double gap and replaced by one (until one remains), check the characters https://htmlweb.ru/html/symbols.php and remove them ) Do you need to leave only letters, numbers and signs of prepainting?- Yes 0 to 0.Itemno leaves I don't see such a column in the example.xlsx file - yes this column is simply transferred - to the end of the file 1 .Master_SKU = we take the BRAND column and go checking on https://docs.google.com/spreadsheets/d/1pAS5ZiSrD6aMkdj2i_XMCyMxzMYTcxXgoM2kgeUGwDk/edit#gid=0 (We can simply upload to the system and then update this file) to the first column "A" if match we take the column "B" and add MANUFACTURER_SKU result = Accu-Tac-SRS0200 You can make a reference to the Google table for the data.However, Google allows you to request data a limited number once a day (the exact numbers I don’t remember, you need to read the documentation of Google).Is the app intended to be used only on a single car?- Yes For other processing schemes, will this information be valuable?- Yes 2ndProduct_type = All products are “simple” ThreeManufacturer_Part_Number = MANUFACTURER_SKU 4 .Title = LONG_DESCRIPTION (Every word with a big letter, at the end we put the thire and MANUFACTURER_SKU) example "AccuTac SRS0200 G1 Spikes SR5/BR4 BiPod Feet Aluminum Black - SRS0200" - remove the repetition of the value (if the long dictionary is equal to the value with MANUFACTURER_SKU) Not quite correct description, based on the example "SR5/BR4" should be in the upper register, also for "BiPod" is used "Camel Case", "SRS0200" also fully in the upper register.ITEM_MASTER.csv contains 28 lines with an empty LONG_DESCRIPTION- leave the title empty It is necessary to exhibit the DLLSTR(E70) formula. 6 .Description = MANUFACTURER_TEXT 7 .Thumbnail_Image = LARGE_LINK Example: https://media.server.theshootingwarehouse.com/large/21779.jpg should be replaced by https://nightgalaxy.sellware.net/img/S/Sports_South/21779.jpg You need to replace a part of the “media.server.theshootingwarehouse.com/large” link with “nightgalaxy.sellware.net/img/S/Sports_South” ?There may be some additional logic of replacement – just that.8 .Main_Image = copy of the column Thumbnail_Image The 9.UPC = UPC_EAN must contain from 12 characters (all numbers with less than 12 characters in front add 0) Do I need UPC validation?No is.If UPC is empty to fill the field with zero?No is.The 10.MAP_Price = MAP 11 of 11.Cost_price = discount_price cat NG_LG = combining two columns D and E = D2&"/"&E2 result: ACCESSORIES/ACCESSORIES MISCELLANEOUS ebay_nightgalaxy:Store_Category_1 = leave empty ebay_nightgalaxy:Category_1 = leave empty 15 .CAT EBAY = leave empty 16 .Lead_Time_To_Ship = always 1 Link = All time 1 18 .Status = Always 1 ebay night galaxy:Attribute_Name_1 logic is described on the site, values (TYPE, MODEL, SIZE, TUBE DIAMETER, DIMENSIONS, COLOR, MATERIAL, HAND, FIREARM FIT, FINISH, BELT SIZE, CAPACITY, BARREL LENGTH.Brand, MPN and Country The same attributes that should always be an example on the site.Keywords that you can check by the file and immediately exclude the products: M1 (M-1), M4 (M-4), M14, Mini 14, M-14, M16 (M-16), M14 (M-14), M4/M16, M30 (M-30), Model 4, Model 15, AR, AR15 (AR-15), AK47 (AK-47), A2, A3, A4, AR10 (AR-10), AR, LR-308, AR1, FN FAL, PS90, P90, M-LOK" is a complete list?Where to look for them?To ignore the lines with these words?In the title, discreet.The attributes that should always be that?"Firearms and accessories policy" & "Knives policy" How to recognize such products in a file?21 of 21.Length = SHIPPING_LENGTH 22 is.Width = SHIPPING_WIDTH 23 .Height = Shipping_Height 24 is.Weight = Weight 25 .Dimensions_Unit = value always in ebay_nightgalaxy:Template = Weight check Up to 1 lbs = "MO - up to 1 lbs - DI+ - 1" 1 - 2 lbs = "MO - 1 - 2 lbs - DI+ - 1" 2 - 9 lbs = "MO - 2 - 9 lbs - DI+ - 1" 9+ = "MO - 9 + lbs - DI+ - 1" If the product Length, Height, Weight, Width is more than 35 (even if one of these parameters is suitable then we put Domestic instead of the word DI+ The ITEM_MASTER.csv file in columns with sizes contains values of the type "0.20" (the leading zero is left).Should it be added?The decimal divider in the finished file is always a point?Do I need to round the value type "10.995"?Leaving up to 5 characters - 10.99

Proposals 3 Rejected 1