Freelance projects

Freelance projects

Importing goods to OpenCart at BD level (MySQL+PHP)

Data Parsing, PHP — incorrectly specified categories?

56 USD

Client's review of cooperation with Oleksandr S.

Importing goods to OpenCart at BD level (MySQL+PHP)

56 USD

A very professional approach to work, the executor succeeds in the smallest details, offers solutions. I recommend it!

5.0

Oleg S.

Reciprocal Feedback

22 February 2023

Freelancer's review of cooperation with Oleg S.

Importing goods to OpenCart at BD level (MySQL+PHP)

56 USD

The scope of the work turned out to be a bit greater and more complex than in the initial task. The first stage is completed. It is very pleasant to work with the customer, understands the specifics, I recommend. We will continue further.

5.0

Oleksandr S.

Reciprocal Feedback

22 February 2023

Project translated automatically. Log in or register, to view the original So it came out that the import to the BD of the new site was made through XML feed.And a part of the goods (about 900) did not get to the new site.From the old site (osCommerce) transferred to the new site (OpenCart) table of products and categories that are named accordingly: old_products, old_categories, old_categories_description, old_products_to_categories 1 .A list of goods to be imported. To select missing goods, you need to meet approximately the following request: Select old_products* FROM old_products LEFT OUTER JOIN oc_product ON old_products.products_model = oc_product.sk WHERE oc_product.sk IS NULL However, then you still need to draw the product categories and do LEFT JOIN according to the result of the previous request (usually, you can create temporary tables).But importing in OpenCart is too early The 2ndAfter such preparation of the goods to import, you need to do cleaning from excessive HTML formating of the product description.That is, to get with the help of strip_tags() excess tags style, h1, h2, h3 and so on, but remaining b, i, strong and so on - there is a list.Moreover, there is a ready PHP code, which cleansing is made for previous products.3 .In addition, in the product descriptions for import, it is necessary to adjust the URLs of the images so that they indicate a new site (cover https://address-old site).and 4.And, in the descriptions, the links to the video on YouTube are inserted, but the curve (through x-shockwave-flash) on the old site - you need to correct it so that the video on the new site appears properly.and 5.In addition, on the goods (translation) works a content manager, and it is desirable that new imported goods be marked somehow for the content manager (tags or properties) to distinguish new goods.6 .The new website is two-speaking (Ukr/Rus), so when importing it should be noticed.For translation the purchased module https://opencartforum.com/files/file/5277-perevod-na-vse-yazyki-sayta-tovary-kategorii-stati/ there are the following options to filter the goods for translation: 7 .The final result of the work: processed goods, as mentioned above, and imported to OpenCart (probably the imports are better performed through the CSV file rather than directed in the BD).

Proposals 4 Discussions 3

Gregory P. 7 February 2023

В общем, сумму можно смело подимать раза в 3? Тем более, что ни файл импорта, ни сайт не были засвечены. И подходов может быть несколько.

Oleg S.

7 February 2023

Стоимость работ указывает исполнитель
ТЗ довольно подробное, как на мой взгляд, достаточное для оценки
Подходы и стоимость можно обсудить в личной переписке

Denis Kisel 8 February 2023

В данном случае помоему проще было бы поправить модуль импорта xml, что бы корректно залились все товары

Add Comment

Current freelance projects in the category Data Parsing

Reddit API

Web Programming 24 proposals 30 July

Not specified
Website parsing, bypassing Akamai protection

Python 39 proposals 30 July

Not specified
Парсинг маркетплейсу

Bot Development 31 proposals 30 July

38 USD
Automatic import of prices from supplier price lists in Google Sheets CSV format to HOROSHOP

Web Programming 66 proposals 29 July

111 USD
Find and add links to photos for 900 airplanes.

Data Processing 33 proposals 28 July

45 USD

Oleg S.
Kyiv, Ukraine
dRe

Projects 133
Rating 5.0
Rating 5 947

Importing goods to OpenCart at BD level (MySQL+PHP)

Client's review of cooperation with Oleksandr S.

Importing goods to OpenCart at BD level (MySQL+PHP)

5.0

Oleg S.

Freelancer's review of cooperation with Oleg S.

Importing goods to OpenCart at BD level (MySQL+PHP)

5.0

Oleksandr S.

Proposals concealed

Proposals are currently absent

Current freelance projects in the category Data Parsing

Reddit API

Website parsing, bypassing Akamai protection

Парсинг маркетплейсу

Automatic import of prices from supplier price lists in Google Sheets CSV format to HOROSHOP

Find and add links to photos for 900 airplanes.